Creating Charts

In this section:

How to:

Charts communicate overall trends quickly with eye-catching and intuitive graphics. Charts come in many different varieties that allow you to communicate information with varying degrees of complexity and specificity. You can use simple charts to effectively communicate simple metrics, and more complex charts to clearly display relationships between different aspects of your data, making it easy to identify less obvious trends.

Different chart types utilize different kinds of data and enable different styling options. You can easily change chart types by selecting a different option from the Content picker, making it easy to ensure that you choose the chart type that best represents your data.

When creating your visualization, you can use tooltips and on-chart filtering to get the necessary information from your chart, and you can also enhance the chart with run-time capabilities such as drill-downs and In-Document Analytics to make even more information available from a single chart.

Procedure: How to Create a Chart Using WebFOCUS Designer

  1. Open WebFOCUS Designer. On the WebFOCUS Hub, click the plus menu and then click Create Visualizations, or, on the WebFOCUS Home Page, click Visualize Data.

    WebFOCUS Designer opens in a new browser tab.

  2. Select a workspace and a data source available from that workspace.

    Once you select a data source, WebFOCUS Designer loads with options to create a single content item.

  3. Use the Content picker to change the chart type, or use the default vertical stacked bar chart. The Content picker is shown in the following image.
  4. Add measures by dragging them onto the canvas.

    Note: You can also double-click a measure to add it to the default measure bucket or drag it into an appropriate bucket of your choice.

  5. Add dimensions by dragging them onto the canvas.

    Note: You can also double-click a dimension to add it to the default dimension bucket or drag it into an appropriate bucket of your choice.

    The chart refreshes with your selections.

  6. You can format your chart in the following ways:
    1. Edit the style, size, or format of your fonts.
    2. Modify the appearance or location of your legend.
    3. Modify axis options.
    4. Add a header and footer.
    5. Customize the series in your chart.
  7. On the WebFOCUS Designer toolbar, click Save to save your chart.

    When you create a single chart and save it for the first time, it is saved as a stand-alone chart, which allows you to add it as external content to pages. If you click Convert to page on the Visualization toolbar, your content becomes a page to which you can add more content and containers. After this point, it is saved as a multi-content page.

    You can now continue editing your chart, or add more charts to the visualization to turn it into a page.

  8. To reopen your chart once you have exited WebFOCUS Designer, locate it on the Hub, right-click it, and click Edit from the shortcut menu.

Creating Vertical Stacked Bar Charts

How to:

Use a vertical stacked bar chart when you want to view information for one dimension within another dimension. For example, when you want to see which product subcategories accounted for the most sales within each product category.

If you use one measure in the Vertical bucket and one dimension in the Horizontal bucket, a simple bar chart is created, with no stacked segments. Vertical stacked bar charts require at least one measure and one dimension. If you add a second measure to the Vertical bucket, a second series is created for the new measure and a new segment is placed on top of the first measure in each bar, as shown in the following image.


Stacked bar chart with 2 measures

Additional measures increase the number of segments in a stack.

If you instead add a dimension field to the Color bucket, colored segments are created for each value in that dimension field, as shown in the following image.


Stacked bar chart with a Color field

Additional fields added to the color field create additional segments based on concatenated values.

The following display options are available for a vertical stacked bar chart:

You can add fields to the following buckets for a vertical stacked bar chart:

Procedure: How to Create a Vertical Stacked Bar Chart

  1. Open WebFOCUS Designer. On the WebFOCUS Hub, click the plus menu and then click Create Visualizations, or, on the WebFOCUS Home Page, click Visualize Data.

    WebFOCUS Designer opens in a new browser tab.

  2. Select a workspace and a data source available from that workspace.

    Once you select a data source, WebFOCUS Designer loads with options to create a single content item.

    Vertical stacked bar is the default chart type. If you have a different content type selected by default, select the vertical stacked bar chart option from the Content picker.

  3. Add one or more measures and dimensions to the chart.

    The vertical stacked bar chart refreshes with your selections.

  4. You can perform the following tasks with your vertical stacked bar chart:
    1. Add additional measures or dimensions to the chart, where applicable.
    2. Change the fields to obtain different information.
    3. Format the chart (for example, customize the header and footer or style the legend).
  5. Save your vertical stacked bar chart as a stand-alone chart, or as part of a page.

Creating Horizontal Bar Charts

How to:

Use a horizontal bar chart when you want to emphasize a ranking relationship in descending order. This chart type can also be used when the x-axis label is too long to fit legibly side-by-side.

If you add additional measure fields to the Horizontal bucket or add dimension fields to the Color bucket, additional bars are placed in groups for each vertical axis value. A horizontal bar chart with multiple dimension fields is shown in the following image.

Horizontal bar chart

Note: Horizontal bar charts require at least one measure and one dimension. Add measures as required to compare additional values.

To sort the bars from high to low, right-click a measure value in the Horizontal bucket and click Sort descending.

The following display options are available for a horizontal bar chart:

Note: When sorting a bar chart, each series is treated as a unique bar. As a result, groups of series such as stacked bar segments, side-by-side groups, or absolute overlapping bars may be separated.

You can add fields to the following buckets for a horizontal bar chart:

Procedure: How to Create a Horizontal Bar Chart

  1. Open WebFOCUS Designer. On the WebFOCUS Hub, click the plus menu and then click Create Visualizations, or, on the WebFOCUS Home Page, click Visualize Data.

    WebFOCUS Designer opens in a new browser tab.

  2. Select a workspace and a data source available from that workspace.

    Once you select a data source, WebFOCUS Designer loads with options to create a single content item.

  3. On the Content picker, change the chart type to a horizontal bar chart.
  4. Add a measure and a dimension to the chart.
  5. You can perform the following tasks with your horizontal bar chart:
    1. Add additional measures or dimensions to the chart, where applicable.
    2. Change the fields to obtain different information.
    3. Format the chart (for example, customize the header and footer or style the legend).
  6. Save your horizontal bar chart.

Creating Vertical Side-by-Side Bar Charts

How to:

Vertical side-by-side bar charts can be used to show additional measure or dimension values for each horizontal axis value using differing identifying colors. Side-by-side bar charts are useful to directly compare the values for different measures or categories within each horizontal axis sort value. The following image shows a vertical side-by-side bar chart with one dimension field and multiple measure fields.


Vertical side-by-side bar chart

Note: This chart requires at least one measure and one dimension. Add measures as required to compare additional values.

The following display options are available for a vertical side-by-side bar chart:

You can add fields to the following buckets for a vertical side-by-side bar chart:

Procedure: How to Create a Vertical Side-by-Side Bar Chart

  1. Open WebFOCUS Designer. On the WebFOCUS Hub, click the plus menu and then click Create Visualizations, or, on the WebFOCUS Home Page, click Visualize Data.

    WebFOCUS Designer opens in a new browser tab.

  2. Select a workspace and a data source available from that workspace.

    Once you select a data source, WebFOCUS Designer loads with options to create a single content item.

  3. Add one or more measures and dimensions to the chart.
  4. You can perform the following tasks with your vertical side-by-side bar chart:
    1. Add additional measures or dimensions to the chart, where applicable.
    2. Change the fields to obtain different information.
    3. Format the chart (for example, customize the header and footer or style the legend).
  5. Save your vertical side-by-side bar chart.

Creating Ring Pie Charts

How to:

Use a ring pie chart when you want to review the value of each segment, which represents the measure value for the selected dimension, as it relates to the total for the selected measure. The total value represented by all segments displays in the middle of the ring pie chart. The following image shows a ring pie chart.


ring pie chart

Note: Ring pie charts require at least one measure (placed in the Measure bucket) and one dimension (placed in the Color bucket). Add additional measures as required to create a separate ring pie for each measure.

The following display options are available for a ring pie chart:

You can add fields to the following buckets in a ring pie chart:

Procedure: How to Create a Ring Pie Chart

  1. Open WebFOCUS Designer. On the WebFOCUS Hub, click the plus menu and then click Create Visualizations, or, on the WebFOCUS Home Page, click Visualize Data.

    WebFOCUS Designer opens in a new browser tab.

  2. Select a workspace and a data source available from that workspace.

    Once you select a data source, WebFOCUS Designer loads with options to create a single content item.

  3. On the Content picker, change the chart to a ring pie chart.
  4. Add one measure and a dimension to the chart.

    The ring pie chart refreshes with your selections.

  5. You can perform the following tasks with your ring pie chart:
    1. Add additional measures or dimensions to the chart, where applicable.
    2. Change the fields to obtain different information.
    3. Format the chart (for example, customize the header and footer or style the legend).
    4. Change the size of the hole in the ring pie chart. On the Format tab, select Series from the area menu, then adjust the value of the Hole Size % property. Setting this property to 0 removes the hole entirely, creating a standard pie chart.
  6. Save your ring pie chart.

Creating Absolute Line Charts

How to:

Use absolute line charts when you want to show trend data over time. For example, monthly changes in employment figures, or yearly sales of an item in your inventory.

Note: Absolute line charts require at least one measure and one dimension. Adding multiple measures or adding fields to the Color bucket will create additional lines on the chart, as shown in the following image.


Line chart

The following display options are available for a line chart:

You can add fields to the following buckets for a line chart:

Procedure: How to Create an Absolute Line Chart

  1. Open WebFOCUS Designer. On the WebFOCUS Hub, click the plus menu and then click Create Visualizations, or, on the WebFOCUS Home Page, click Visualize Data.

    WebFOCUS Designer opens in a new browser tab.

  2. Select a workspace and a data source available from that workspace.

    Once you select a data source, WebFOCUS Designer loads with options to create a single content item.

  3. On the Content picker, change the chart to an absolute line chart.
  4. Add one or more measures and a dimension to the chart.
  5. You can perform the following tasks with your absolute line chart:
    1. Add additional measures or dimensions to the chart, where applicable.
    2. Change the fields to obtain different information.
    3. Format the chart (for example, customize the header and footer or style the legend).
  6. Save your absolute line chart.

Creating Vertical Stacked Area Charts

How to:

Use vertical stacked area charts when you want to distinguish your data more dramatically by highlighting volume with color. In a vertical stacked area chart, each area is stacked on top of the sections below it, as shown in the following image.


stacked area chart

Note: Vertical stacked area charts require at least one measure and one dimension. Adding multiple measures will create additional shaded areas on the chart.

The following display options are available for an area chart:

You can add fields to the following buckets for an area chart:

Procedure: How to Create a Vertical Stacked Area Chart

  1. Open WebFOCUS Designer. On the WebFOCUS Hub, click the plus menu and then click Create Visualizations, or, on the WebFOCUS Home Page, click Visualize Data.

    WebFOCUS Designer opens in a new browser tab.

  2. Select a workspace and a data source available from that workspace.

    Once you select a data source, WebFOCUS Designer loads with options to create a single content item.

  3. On the Content picker, change the chart to a vertical stacked area chart.
  4. Add one or more measures and a dimension to the chart.

    The vertical stacked area chart refreshes with your selections.

  5. You can perform the following tasks with your vertical stacked area chart:
    1. Add additional measures or dimensions to the chart, where applicable.
    2. Change the fields to obtain different information.
    3. Format the chart (for example, customize the header and footer or style the legend).
  6. Save your vertical stacked area chart.

Creating Scatter/Bubble Charts

How to:

Scatter charts are used to show relationships between X and Y values. They compare two sets of numbers at once, which is useful for discovering patterns and trends.

A bubble chart is a chart in which the data points are represented by bubbles. Bubble charts can have two column fields representing X and Y data values, or have three column fields representing X, Y, and Z data values, in that order. The third variable (Z) represents size. The size of each bubble is used to show the relative importance of the data. A bubble chart can be used to effectively show the relationship between three measure fields, as shown in the following image.


bubble chart

Note: Scatter/bubble charts require at least two measures, and one dimension, which can be a color field or detail field. Optionally, add a dimension to the Size bucket using the count aggregation to view the concentration of data.

The following display options are available for a scatter plot or bubble chart:

You can add fields to the following buckets for a scatter plot or bubble chart:

Procedure: How to Create a Scatter/Bubble Chart

  1. Open WebFOCUS Designer. On the WebFOCUS Hub, click the plus menu and then click Create Visualizations, or, on the WebFOCUS Home Page, click Visualize Data.

    WebFOCUS Designer opens in a new browser tab.

  2. Select a workspace and a data source available from that workspace.

    Once you select a data source, WebFOCUS Designer loads with options to create a single content item.

  3. On the Content picker, change the chart to a scatter or bubble chart.
  4. Add one measure and one dimension to the chart. Also, add fields in the Detail and Color buckets.

    The scatter/bubble chart refreshes with your selections.

  5. You can perform the following tasks with your scatter/bubble chart:
    1. Add additional measures or dimensions to the chart, where applicable.
    2. Change the fields to obtain different information.
    3. Format the chart (for example, customize the header and footer or style the legend).
    4. Add trend lines. On the Format tab, select Series from the quick access menu and, with all series or a single series selected, click Show trend line. You can set the line style, trend line equation format, and, when using the polynomial equation, set the order or degree of the expression.
  6. Save your scatter/bubble chart.

Creating Circle Plot Charts

How to:

Use circle plot charts to display differing values in rows, enabling you to draw inferences as to how the values overlap. An example of a circle plot is shown in the following image.


circle plot chart

Note: Circle plot charts require at least one measure and one dimension, as well as one for the Detail and Color buckets. Optionally, add a dimension to the Size bucket with the count aggregation to view the concentration of data.

The following display options are available for a circle plot chart:

You can add fields to the following buckets for a circle plot chart:

Procedure: How to Create a Circle Plot Chart

  1. Open WebFOCUS Designer. On the WebFOCUS Hub, click the plus menu and then click Create Visualizations, or, on the WebFOCUS Home Page, click Visualize Data.

    WebFOCUS Designer opens in a new browser tab.

  2. Select a workspace and a data source available from that workspace.

    Once you select a data source, WebFOCUS Designer loads with options to create a single content item.

  3. On the Content picker, change the chart to a circle plot.
  4. Add one measure, one dimension to the chart. Also, add a field into the Detail and Color buckets.

    The circle plot chart refreshes with your selections.

  5. You can perform the following tasks with your circle plot chart:
    1. Add additional measures or dimensions to the chart, where applicable.
    2. Change the fields to obtain different information.
    3. Format the chart (for example, customize the header and footer or style the legend).
  6. Save your circle plot chart.

Creating Treemap Charts

How to:

Treemap charts can be used to display large amounts of hierarchically structured data. Using a set of nested rectangles to illustrate data relationships, sections of a treemap represent branches of a tree. A treemap is shown in the following image.


treemap

Note: Treemap charts require at least one measure and one dimension, to be placed in the Size and Color buckets. Groups are determined by those fields specified in the Grouping bucket.

The following content display options are available for a treemap:

You can add fields to the following buckets for a treemap:

Procedure: How to Create a Treemap Chart

  1. Open WebFOCUS Designer. On the WebFOCUS Hub, click the plus menu and then click Create Visualizations, or, on the WebFOCUS Home Page, click Visualize Data.

    WebFOCUS Designer opens in a new browser tab.

  2. Select a workspace and a data source available from that workspace.

    Once you select a data source, WebFOCUS Designer loads with options to create a single content item.

  3. On the Content picker, change the chart to a treemap chart.
  4. Add one measure, one dimension to the chart. Also, add a field into the Size and Color buckets.

    The treemap chart refreshes with your selections.

  5. You can perform the following tasks with your treemap chart:
    1. Add additional measures or dimensions to the chart, where applicable.
    2. Change the fields to obtain different information.
    3. Format the chart (for example, customize the header and footer or style the legend).
  6. Save your treemap chart.

Creating Matrix Marker Charts

How to:

Matrix marker charts can be used to analyze one or two measures against a crosstab of two categorical dimensions. The result is a color scaled matrix chart that shows categorized trends, as shown in the following image.


matrix marker chart

Note: Matrix marker charts require at least two measures and two dimensions. It also requires a field in the Color and Size buckets, which allow you to see the concentration of data for that intersection of the chart.

The following display options are available for a matrix marker chart:

You can add fields to the following buckets for a matrix marker chart:

Procedure: How to Create a Matrix Marker Chart

  1. Open WebFOCUS Designer. On the WebFOCUS Hub, click the plus menu and then click Create Visualizations, or, on the WebFOCUS Home Page, click Visualize Data.

    WebFOCUS Designer opens in a new browser tab.

  2. Select a workspace and a data source available from that workspace.

    Once you select a data source, WebFOCUS Designer loads with options to create a single content item.

  3. On the Content picker, change the chart to a matrix marker chart.
  4. Add two measures and two dimensions to the chart. Also, add fields to the Color and Size buckets.

    The matrix marker chart refreshes with your selections.

  5. You can perform the following tasks with your matrix marker chart:
    1. Add additional measures or dimensions to the chart, where applicable.
    2. Change the fields to obtain different information.
    3. Format the chart (for example, customize the header and footer or style the legend).
  6. Save your matrix marker chart.

Creating Statistical Box Plot Charts

How to:

A box plot, also known as a box-and-whisker plot, is a chart type that provides distribution information about your data. The box represents the range between the upper and lower quartiles, and the line inside the box represents the median. The whiskers represent the maximum and minimum with outliers excluded, and outliers are represented by individual points. An example of a box plot is shown in the following image.


boxplot

Since box plots display the distribution of points in your data, you need to provide detail values. You can do this in one of two ways. One option is to add a dimension field to the Detail bucket. This field should have a large number of distinct values in order to generate a sufficient spread of data for the box plot. For example, in the image above, a separate box plot is created for each Product Category to show the distribution of values in the Model field, which has been placed in the Detail bucket.

Another option is to incorporate your entire data set into the box plot. You can do this by changing the calculation method from Summaries to Details. In this case, you do not need a field in the Detail bucket to generate the box plot. The following image shows a box plot chart in which separate box plots are still generated for each product category, but which uses the Details calculation option instead of using Model as the Detail field. Since more data values are used in this chart, there are more outliers.


boxplot with detail aggregation

The following display options are available for a box plot:

You can add fields to the following buckets for a box plot chart:

Procedure: How to Create a Box Plot Chart

  1. Open WebFOCUS Designer. On the WebFOCUS Hub, click the plus menu and then click Create Visualizations, or, on the WebFOCUS Home Page, click Visualize Data.

    WebFOCUS Designer opens in a new browser tab.

  2. Select a workspace and a data source available from that workspace.

    Once you select a data source, WebFOCUS Designer loads with options to create a single content item.

  3. On the Content picker, change the chart to a statistical box plot.
  4. Add a measure to the Vertical bucket and a dimension to the Horizontal bucket.

    A single measure value displays as a line in each column.

  5. Use one of the following methods to generate a set of data for each column:
    • Add a dimension field to the Detail bucket. This field should provide multiple records for Horizontal bucket value.
    • Change the calculation option from Summaries to Details Detail (PRINT) icon. If you have a very large data source, this may generate too many records to evaluate in the box plot.

    A set of box plots appears on the canvas, showing indicators for outliers, maximum and minimum, median, and upper and lower quartiles.

  6. You can perform the following tasks with your box plot chart:
    1. Add additional measures or dimensions to the Tooltip, Animate, and MultiPage buckets, where applicable.
    2. Change the fields to obtain different information.
    3. Format the chart (for example, customize the header and footer , change the series colors, or set box plot-specific properties).
  7. Save your box plot chart.

Creating Proportional Symbol Maps

How to:

Proportional symbol maps, or bubble maps, use symbols of different sizes to represent data associated with different areas or locations within the map, as shown in the following image.


bubble map

Note: Proportional symbol maps require at least one measure and one Georole, which contains geographic location information. You can add a field to the Color bucket to color the map.

The following display options are available for a proportional symbol map.

You can add fields to the following buckets for a proportional symbol map:

Procedure: How to Create a Proportional Symbol Map

  1. Open WebFOCUS Designer. On the WebFOCUS Hub, click the plus menu and then click Create Visualizations, or, on the WebFOCUS Home Page, click Visualize Data.

    WebFOCUS Designer opens in a new browser tab.

  2. Select a workspace and a data source available from that workspace.

    Once you select a data source, WebFOCUS Designer loads with options to create a single content item.

  3. On the Content picker, change the chart to a bubble map.
  4. Add measures to the Color and Size buckets and one field with an assigned geographic role to the Location bucket.

    The proportional symbol map refreshes with your selections.

    Note: In this case, we have also added Product,Subcategory to add color to the map.

  5. You can perform the following tasks with your proportional symbol map:
    1. Change the field in the Location bucket to analyze other trends.
    2. Zoom in or out to see different views of the data.
  6. Save your proportional symbol map.

Creating Choropleth Maps

How to:

Choropleth maps can be used to create geographically-based heat maps. They are useful for visualizing location-based data, trends, and distributions across a geographic area, as shown in the following image.


choropleth map

Note: Choropleth maps require at least one measure and one Georole, which contains geographic location information. You can add a field to the Color bucket to color the map.

The following display options are available for a choropleth map.

You can add fields to the following buckets for a choropleth map:

Procedure: How to Create a Choropleth Map

  1. Open WebFOCUS Designer. On the WebFOCUS Hub, click the plus menu and then click Create Visualizations, or, on the WebFOCUS Home Page, click Visualize Data.

    WebFOCUS Designer opens in a new browser tab.

  2. Select a workspace and a data source available from that workspace.

    Once you select a data source, WebFOCUS Designer loads with options to create a single content item.

  3. On the Content picker, change the chart to a choropleth map.
  4. Add a measure to the Color bucket and one field with an assigned geograhic role to the Location bucket.

    The choropleth map refreshes with your selections.

  5. You can perform the following tasks with your choropleth map:
    1. Change the field in the Location bucket to analyze other trends.
    2. Zoom in or out to see different views of the data.
  6. Save your choropleth map.

Creating Data Grids

How to:

A data grid is a kind of chart that can be used to present data in tabular form. For example, you can create a grid (table) that summarizes your data. Data grids include sorting and tooltip features by default, unlike tabular reports. An example of a data grid is shown in the following image.


data grid

Note: Data grids require at least one measure and one dimension. Additional measures create unique columns. You can add multiple dimensions in the Row bucket to create customized rows based on the structure of your selection, and add dimensions to the Column bucket to create groups of measure columns based on dimension values.

The following display options are available for a data grid:

You can add fields to the following buckets for a data grid:

Procedure: How to Create a Data Grid

  1. Open WebFOCUS Designer. On the WebFOCUS Hub, click the plus menu and then click Create Visualizations, or, on the WebFOCUS Home Page, click Visualize Data.

    WebFOCUS Designer opens in a new browser tab.

  2. Select a workspace and a data source available from that workspace.

    Once you select a data source, WebFOCUS Designer loads with options to create a single content item.

  3. On the Content picker, select Data Grid (Chart).
  4. Add one or more measures and dimensions to the chart.

    The data grid refreshes with your selections.

  5. You can perform the following tasks with your data grid:
    1. Add additional measures or dimensions to the chart, where applicable.
    2. Change the fields to obtain different information.
    3. Format the chart (for example, customize the header and footer or style the legend).
  6. Save your data grid.

Creating Waterfall Charts

How to:

Waterfall charts allow you to see incremental positive and negative changes in your data, resulting in a rolling total. Positive and negative values are represented by different colored risers that start at the end point of the previous riser. Waterfall charts can be a good way to show change over time. An example of a waterfall chart is shown in the following image.


waterfall chart

The following display options are available for a waterfall chart:

You can add fields to the following buckets for a waterfall chart:

Procedure: How to Create a Waterfall Chart

  1. Open WebFOCUS Designer. On the WebFOCUS Hub, click the plus menu and then click Create Visualizations, or, on the WebFOCUS Home Page, click Visualize Data.

    WebFOCUS Designer opens in a new browser tab.

  2. Select a workspace and a data source available from that workspace.

    Once you select a data source, WebFOCUS Designer loads with options to create a single content item.

  3. On the Content picker, change the chart to a waterfall chart.
  4. Add one measure to the Vertical bucket, and one dimension to the Horizontal bucket.

    The waterfall chart refreshes with your selections. Any positive values display in green, and any negative values display in red, by default. There is also a Total column, which displays in blue by default.

  5. You can perform the following tasks with your waterfall chart:
    1. Add additional measures or dimensions to the Tooltip, Animate, or MultiPage buckets of the chart, where applicable.
    2. Change the fields to obtain different information.
    3. Format the chart (for example, customize the header and footer or add data labels).
  6. Save your waterfall chart.

Creating Gauge Charts

How to:

A gauge is a simple visual that shows a measure value. These can be used to create straightforward KPI graphics, or use matrix rows and columns to compare data for different sort values. The following example shows a gauge chart with matrix rows.


matrix gauge chart

The following display options are available for a gauge chart:

You can add fields to the following buckets for a gauge chart:

Procedure: How to Create a Gauge Chart

  1. Open WebFOCUS Designer. On the WebFOCUS Hub, click the plus menu and then click Create Visualizations, or, on the WebFOCUS Home Page, click Visualize Data.

    WebFOCUS Designer opens in a new browser tab.

  2. Select a workspace and a data source available from that workspace.

    Once you select a data source, WebFOCUS Designer loads with options to create a single content item.

  3. On the Content picker, change the chart to a gauge chart.
  4. Choose a gauge type from the display options. Simple, Circular, and KPI gauge types are available.
  5. Add one measure to the Measure bucket.

    The gauge loads to display the value of the measure field.

  6. You can make the following additional customizations to your gauge chart:
    1. Create a matrix chart by adding dimension fields to the Vertical and Horizontal buckets.
    2. Add additional measures or dimensions to the Tooltip, Animate, or MultiPage buckets of the chart, where applicable.
    3. Change the fields to obtain different information.
    4. Format the chart (for example, customize the header and footer or change the series color).
  7. Save your gauge chart.

Creating Funnel Charts

How to:

A funnel chart shows values of a dimension field as a proportion of the whole, similar to a bar in a stacked bar chart. The shape of the funnel makes it useful to show information about processes that involve cascading or narrowing down due to the hierarchy it implies. For example, the following image shows revenue by year in a funnel chart. The entire funnel can be taken to represent all sales, with the top segment representing the most recent year, the top two segments the two most recent years, and so on.


funnel chart

Conversely, you can use the pyramid option to show values in an implied hierarchy, as shown in the following image of a pyramid chart showing revenue by age range. The oldest range, 70-85 is at the top, and the youngest range, 13-17, is at the bottom.


pyramid chart

The following display options are available for a funnel chart:

You can add fields to the following buckets for a funnel chart:

Procedure: How to Create a Funnel Chart

  1. Open WebFOCUS Designer. On the WebFOCUS Hub, click the plus menu and then click Create Visualizations, or, on the WebFOCUS Home Page, click Visualize Data.

    WebFOCUS Designer opens in a new browser tab.

  2. Select a workspace and a data source available from that workspace.

    Once you select a data source, WebFOCUS Designer loads with options to create a single content item.

  3. On the Content picker, change the chart to a funnel chart.
  4. Add at least one measure to the Measure bucket and a dimension to the Color bucket.

    The funnel chart loads, showing each dimension field as a layer with height based on the value of the measure field.

  5. You can make the following additional customizations to your funnel chart:
    1. Change the funnel chart to a pyramid chart.
    2. Add additional measures or dimensions to the Tooltip, Animate, or MultiPage buckets of the chart, where applicable.
    3. Change the fields to obtain different information.
    4. Format the chart (for example, customize the header and footer or change the series color).
  6. Save your funnel chart.

Creating Mekko Charts

How to:

A Mekko chart allows you to see proportional values of a measure field for two dimension fields. The intersections of these dimension fields and their relative sizes make it possible to quickly identify the most significant combinations of values. An example of a Mekko chart is shown in the following image.


mekko chart

The following display options are available for a Mekko chart:

You can add fields to the following buckets for a Mekko chart:

Procedure: How to Create a Mekko Chart

  1. Open WebFOCUS Designer. On the WebFOCUS Hub, click the plus menu and then click Create Visualizations, or, on the WebFOCUS Home Page, click Visualize Data.

    WebFOCUS Designer opens in a new browser tab.

  2. Select a workspace and a data source available from that workspace.

    Once you select a data source, WebFOCUS Designer loads with options to create a single content item.

  3. On the Content picker, change the chart to a Mekko chart.
  4. Add one measure to the Vertical bucket and a dimension to the Horizontal and Color buckets.

    The Mekko chart loads to display the proportional value of the measure field for each segment in each column.

  5. You can make the following additional customizations to your Mekko chart:
    1. Add additional measures or dimensions to the Tooltip, Animate, or MultiPage buckets of the chart, where applicable.
    2. Change the fields to obtain different information.
    3. Format the chart (for example, customize the header and footer or change the series color).
  6. Save your Mekko chart.

Creating Tag Clouds

How to:

A tag cloud allows you to see the most frequent or largest values in a dimension field based on the size and color of the text, making it easy to identify the most important values. An example of a tag cloud is shown in the following image.


tag cloud

The following display options are available for a tag cloud:

You can add fields to the following buckets for a tag cloud:

Procedure: How to Create a Tag Cloud

  1. Open WebFOCUS Designer. On the WebFOCUS Hub, click the plus menu and then click Create Visualizations, or, on the WebFOCUS Home Page, click Visualize Data.

    WebFOCUS Designer opens in a new browser tab.

  2. Select a workspace and a data source available from that workspace.

    Once you select a data source, WebFOCUS Designer loads with options to create a single content item.

  3. On the Content picker, change the chart to a tag cloud.
  4. Add a dimension field to the Detail bucket and a measure field to the Size bucket. Optionally, add a measure field to the Color bucket.

    The tag cloud loads, showing each value of the Detail field with a font size determined by the Size field.

  5. You can make the following additional customizations to your tag cloud:
    1. Add additional measures or dimensions to the Tooltip, Animate, or MultiPage buckets of the chart, where applicable.
    2. Change the fields to obtain different information.
    3. Format the chart (for example, customize the header and footer).
  6. Save your tag cloud.

Creating Streamgraphs

How to:

A streamgraph is a simplified area chart. It does not show labels for measure values, but makes it easy to identify trends for different dimension values over time. An example of a streamgraph is shown in the following image.


streamgraph

The following display options are available for a streamgraph:

You can add fields to the following buckets for a streamgraph:

Procedure: How to Create a Streamgraph

  1. Open WebFOCUS Designer. On the WebFOCUS Hub, click the plus menu and then click Create Visualizations, or, on the WebFOCUS Home Page, click Visualize Data.

    WebFOCUS Designer opens in a new browser tab.

  2. Select a workspace and a data source available from that workspace.

    Once you select a data source, WebFOCUS Designer loads with options to create a single content item.

  3. On the Content picker, change the chart to a streamgraph.
  4. Add a measure field to the Vertical bucket, a dimension, such as a date field, to the Horizontal bucket, and another dimension to the Color bucket.

    The streamgraph loads, showing comparative changes for each value in the Color bucket.

  5. You can make the following additional customizations to your streamgraph:
    1. Add additional measures or dimensions to the Tooltip, Animate, or MultiPage buckets of the chart, where applicable.
    2. Change the fields to obtain different information.
    3. Format the chart (for example, customize the header and footer or change series colors).
  6. Save your streamgraph.

Creating Charts Using a Chart Extension

How to:

WebFOCUS supports the ability to add new, custom chart types to its list of built-in charts. These custom chart types are called extensions or plug-ins. Once enabled on your WebFOCUS environment, any extensions that you have added are available when you expand the Content picker, in the Custom section, as shown in the following image.


Chart extensions in Custom section of chart picker

Each chart extension uses a set of buckets and properties unique to that extension. The liquid gauge chart extension uses the Tooltip, Value Bucket, and MultiPage buckets, as shown in the following image.


Buckets for liquid gauge chart

The chord diagram, on the other hand, uses the Tooltip, Source Nodes, Target Nodes, Node Link Values, and MultiPage buckets. It also indicates the type of field that should be used in each bucket, as shown in the following image.


Buckets for a chord chart

Each of these buckets is configured to allow a certain number of fields, and certain types of fields.

Chart extensions also have a unique set of properties that can be applied to them. To access chart extension properties, on the Format tab, with the General option selected from the Quick Access menu, in the Other section, click Extension properties. This opens the Extension properties panel. The Extension properties panel opens on top of the Resources and Properties panels, and can be resized and moved within the browser window. If you click outside of the Extension properties panel, it closes, and any changes that you made to the chart properties are applied.

The Extension properties panel for a liquid gauge chart is shown in the following image.



Some of the properties on the Extension properties panel apply to specific elements of the chart extension. For example, in the following image, the color of the wave in the liquid gauge chart has been changed to a darker shade of blue, and the number of waves has been increased from 1 to 3.


Liquid gauge chart with 3 waves

For more details about the buckets and properties used in specific chart extensions, see the page for each extension on the GitHub site.

Procedure: How to Create a Chart Using a Chart Extension

  1. Open WebFOCUS Designer. On the WebFOCUS Hub, click the plus menu and then click Create Visualizations, or, on the WebFOCUS Home Page, click Visualize Data.

    WebFOCUS Designer opens in a new browser tab.

  2. Select a workspace and a data source available from that workspace.

    Once you select a data source, WebFOCUS Designer loads with options to create a single content item.

  3. Expand the Content picker and, from the Custom section, select a chart extension with which to create your chart.
  4. Add measure and dimension fields to the chart based on the available buckets.
  5. Optionally, style the chart using the available extension-specific properties.
    1. On the Properties panel, select the Format tab.
    2. If it is not already selected, open the Quick Access menu and select General.
    3. In the Other section, click Extension properties. The extension properties panel opens.
    4. Make changes to the desired properties, and then close the extension properties panel.

      The chart updates to reflect your changes to extension properties.

  6. Save your visualization.