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 Multi-Layer Maps in ibi WebFOCUS Designer

In this section:

How to:

Reference:

As an alternative to creating a map procedure in the text editor using WebFOCUS syntax, you can use the user interface in WebFOCUS Designer to create a multi-layer map from a single data source. You can then enhance your map with additional data and content layers, created directly within WebFOCUS Designer or referenced from existing map procedures or configured context layers.

To create a new map in WebFOCUS Designer, on the WebFOCUS start page, click the plus button and then click Create Visualizations. After WebFOCUS Designer opens and you select a data source, from the content picker, change the content type to a map. Once you have changed the content type to a map, you cannot change it back to another chart or report type.

To create a map, start by adding a data layer or content layer, from the Settings tab of the Properties panel. A data layer is created directly in WebFOCUS Designer, from fields in your selected data source. A content layer can be either a single layer map that was saved to your environment, or a context layer configured on the ibi™ WebFOCUS® Reporting Server. You can add multiple data and content layers to your map, and reorder them in the Layers bucket. The layers are drawn on the map in the layer in which they are listed, so the first layer in the list appears underneath the other layers, and the last layer in the list appears on top. The Layers bucket with two data layers and a content layer is shown in the following image.


Layers list in multi-layer map ui

When you add a new data layer, in the Add Data Layer dialog box, you first assign a name to the layer, that will appear in the legend and layers list, and select the type of map layer that you would like to create, as shown in the following image.


Add Data Layer dialog box

A data layer can be a choropleth or a bubble map. You can then populate the map layer by adding fields to the buckets on the Properties panel. Drag a field with a defined geographic role to the Location bucket, and populate the color, tooltip, and, depending on the layer type, size buckets to provide additional information in the map. You can style the selected layer using the options on the Map Properties panel.

To add more layers, click Add Data Layer or Add Content Layer. All layers appear in the Layers bucket, where they can be reordered, hidden, or deleted.

You can also style the run-time map interface from the Map Properties panel. The Map Properties panel provides options to change the basemap, interface style, viewing options, and available run-time tools and widgets. These run-time tools and widgets include the Search bar, Measurement tools, Directions widget, and Location widget. To open the Map Properties panel, click the Map Properties button on the Visualization toolbar. The Map Properties panel is shown in the following image.


Designer multi-layer map properties

From the Map Properties panel, you can set the following properties:

Creating Choropleth Maps in ibi WebFOCUS Designer

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 Clear buckets content display option is available for a choropleth map. It removes the fields from all buckets.

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

  • Color. Use a measure field to apply a color scale to the areas on the choropleth map. You can also use a dimension to color the areas on the map. Each area can show one color, so it is advisable to use overarching categories that apply to distinct sets of points. For example, you could use a country field in the Color bucket to categorize states shown on the map.
  • Location. Enables you to specify a Geolocation field for use in a map. Each value from the field is plotted on the map if it is recognized. A choropleth can plot geographic areas, such as cities, states, or countries.

    Note: Geolocation fields must have an assigned geographic role. Values from the field are matched to values from the geographic role to plot them in the correct location. For example, if your field contains country names, use the Country Name geographic role.

  • Tooltip. The data placed in this bucket displays in the tooltip at run time. This can be used to make additional information available without changing the appearance of the chart.
  • MultiPage. Enables the creation of multiple graphs based on the field that you place in this bucket.

Procedure: How to Create a Choropleth Map in WebFOCUS Designer

  1. Open WebFOCUS Designer. On the default WebFOCUS Home Page, click Visualize Data.

    WebFOCUS Designer opens in a new browser tab.

  2. In WebFOCUS Designer, click the Add data button to select a data source.
  3. 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.

    Note: In order to create a map, the data source that you use must have fields with assigned geographic roles.

  4. On the Content picker, change the chart to a map.
  5. On the Settings tab, in the Layers bucket, click Add Data Layer.

    The Add Data Layer dialog box opens.

  6. Provide an optional name for the layer, and select the Choropleth radio button.
  7. Click Add to create a new choropleth map data layer.
  8. Add a field with an assigned geographic role to the Location bucket. This field can contain place names corresponding to the assigned geographic role, or GIS polygon strings based on an array of coordinate values, created using the GIS_GEOMETRY function.

    The choropleth map refreshes to show the area of each recognized location.

  9. Optionally, enhance the information in the choropleth map in the following ways:
    • Add a measure field to the Color bucket. Areas in the map will be colored based on a color scale, representing measure values for each location.
    • Add a dimension field to the Color bucket. Areas in the map will be colored based on the series color of the associated dimension value.

    Only one field can be added to the Color bucket at a time.

  10. 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.
  11. Save your choropleth map.

Creating Bubble Maps in ibi WebFOCUS Designer

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 Clear buckets content display option is available for a proportional symbol map. It removes the fields from all buckets.

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

  • Size. Use a measure field to determine the size of bubbles on the proportional symbol map.
  • Color. Use a measure field to apply a color scale to the bubbles on the proportional symbol map. You can also use a dimension to color the points on the map. Each point can show one color, so it is advisable to use overarching categories that apply to distinct sets of points. For example, you could use a country field in the Color bucket to categorize points representing states.

    Note: If you add a dimension to the color bucket for a bubble map, each location is visualized as a pie chart when there’s more than one dimension value for the location.

  • Location. Enables you to specify a Geolocation field for use in a map. Each value from the field is plotted on the map if it is recognized. A proportional symbol map can plot geographic areas, such as cities, states, or countries, as well as individual point locations such as street addresses and geographic coordinates.

    Note: Geolocation fields must have an assigned geographic role. Values from the field are matched to values from the geographic role to plot them in the correct location. For example, if your field contains country names, use the Country Name geographic role.

  • Tooltip. The data placed in this bucket displays in the tooltip at run time. Can be used to make additional information available without changing the appearance of the chart.
  • MultiPage. Enables the creation of multiple graphs based on the field that you place in this bucket.

Procedure: How to Create a Bubble Map in WebFOCUS Designer

  1. Open WebFOCUS Designer. On the default WebFOCUS Home Page, click Visualize Data.

    WebFOCUS Designer opens in a new browser tab.

  2. In WebFOCUS Designer, click the Add data button to select a data source.
  3. 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.

    Note: In order to create a map, the data source that you use must have fields with assigned geographic roles.

  4. On the Content picker, change the chart to a map.
  5. On the Settings tab, in the Layers bucket, click Add Data Layer.

    The Add Data Layer dialog box opens.

  6. Provide an optional name for the layer, and select the Proportional radio button.
  7. Click Add to create a new bubble map data layer.
  8. Add a field with an assigned geographic role to the Location bucket. This field can contain place names corresponding to the assigned geographic role, or GIS point strings based on coordinate values.

    The proportional symbol map refreshes to show a point at each recognized location.

  9. Optionally, enhance the information in the proportional symbol map in the following ways:
    • Add a measure field to the Size bucket. Markers in the map will be sized based on the measure values for each location.
    • Add a measure field to the Color bucket. Markers in the map will be colored based on a color scale, representing measure values for each location.
    • Add a dimension field to the Color bucket. Markers in the map will be colored based on the series color of the associated dimension value.

    Only one field can be added to the Color bucket at a time.

  10. 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.
  11. Save your proportional symbol map.

Procedure: How to Change the Default Background of a Map

  1. Create a new map or open an existing map.
  2. Click the Map Properties button.
  3. In the Map Properties panel, open the Basemap menu and choose from the available options, as shown in the following image.
    List of available basemaps
  4. Select one of the following options:
    • Basemap None
    • Dark Gray Canvas Map
    • Dark Gray Vector
    • Light Gray Canvas Map
    • Gray Vector
    • World Imagery with Labels
    • National Geographic World Map
    • Oceans Map
    • Open Street Map
    • World Imagery
    • World Street Map
    • Streets Navigation Vector
    • Streets Night Vector
    • Streets Relief Vector
    • Streets Vector
    • Terrain with Labels
    • World Topographic Map
    • Topographic Vector

    Note: Custom configured basemaps also appear as options.

    Vector basemaps can be more detailed than default raster tile basemaps, but may not be compatible with all environments or basemap styles. For some basemaps, both default raster tile and vector options are available.

    Once you make a selection, the background of the map refreshes. You can continue to change your background until it displays the desired information.

Procedure: How to Add Demographic Layers to a Map

  1. Create a new map or open an existing map.
  2. Click Add Content Layer(s) to add a new content layer.
  3. In the Add Content Layer(s) dialog box, on the Demographic tab, select from various population and lifestyle groups, as shown in the following image.

    Note: These are pre-defined demographic profiles, provided by Esri ArcGIS. Esri periodically retires older demographic layers.

    You can select multiple options in either category to gain additional insight into your data. Specifically, each Demographic Layer has its own profile and provides a layering option, when comparing values across different layers or profiles.

  4. Once you select the demographic layers in the list on the left that you want to use, click Add > to add them to the selected list on the right.
  5. Click Add to add the select layers to the map.

    The Demographic Layers that you select are rendered on the map. The legends for each layer, if they are available, display in the Layers list at run time. The Layer list with a configured demographic layer is shown in the following image.

    legend for Tapestry demographic layer

    You can select and clear the check boxes to enable the display of one or more Demographic Layers to compare and contrast the different demographic scenarios.

    Note: Layers that require a special layerTypeEx property in the addon_json when configured, are not supported in the com.esri.map extension. InfoAssist uses the com.esri.map extension.

Procedure: How to Add Reference Layers to a Map

  1. Create a new map or open an existing map.
  2. Click Add Content Layer(s) to add a new content layer. In the Add Content Layer(s) dialog box, select the Reference tab, as shown in the following image.
  3. Select the reference layers that you want to use from the list on the left, and click Add > to add them to the selected list on the right. Click Add, at the bottom of the dialog box, to add the selected layers to the map.

    Your map refreshes, and the definitions and borders of the References Layers display on the canvas. You can use the Table of Contents or Layers option, to toggle different Reference Layers in your map. These options are shown in the following image.

Reference: Query Buckets by Map Type

This section presents the Query buckets that display, by map type.

Query bucket

Choropleth Map

Proportional Symbol Map

Geo. One data field, specifically a field containing location data (for example, State) with an assigned geographic role.

Color. One measure or dimension field.

Tooltip. One or more data fields (not required).

Multi-page. Up to one data field (not required).

Size. One measure field.

Reference: Geographic Roles

Geographic roles have been unified to access 58 world administrative boundaries down to the postal code level, out of the box. You can access administrative boundaries for approximately 250 countries with a second level license, which is a paid service from Esri. Enter your second level license code by clicking the License button on the ribbon.

Note: Geographic roles are only available with Esri maps.

This section contains information on the geographic roles that are supported for Esri maps.

Geographic Role

Description

Maps Supported

CONTINENT

World Continents

Choropleth, Proportional Symbol

COUNTRY

World Countries

Choropleth, Proportional Symbol

STATE

World Admin Divisions

Choropleth, Proportional Symbol

CITY

World Cities

Choropleth, Proportional Symbol

COUNTY

World Counties

Choropleth, Proportional Symbol

POSTAL-CODE

Postal Code

Choropleth, Proportional Symbol

GEOMETRY_POINT

Geographic Coordinates

Proportional Symbol

Note: This is a new, simplified list of geographic roles (dimensions) that you can utilize when creating a map chart. This unified list of roles provides worldwide mapping of administrative boundaries down to the postal code level. In WebFOCUS Designer, the new roles display, by default, when assigning a geographic role.

The following table illustrates the geographic roles and their dependencies. Level 1 indicates the highest level of hierarchy and level 5 is the lowest level of hierarchy.

Region

Hierarchy Level

Geographic Role

World

1

CONTINENT

2

COUNTRY

3

STATE

4

CITY

5

POSTAL CODE

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.