Working with Charts

 

Charts are the most powerful way to display data in KPIWorX. All charts can be sorted and filtered when using data from AnalytiX-BI.

 

For more information about sorting, filtering, and aggregating charts with AnalytiX-BI data, see On-the-Fly Filtering and Aggregation with AnalytiX-BI.

 

To configure other types of components, see Working with Other Components.

Types of Charts

KPIWorX provides six different charts:

Mapping Data

As described in Add and Modify Widgets and Use the Data Browser, charts can be mapped to data by simply dragging tags from the Data Browser onto the chart or onto the appropriate data field in Widget Settings.

 

To remove a mapping from any field, go to Widget Settings and select the X next to that mapping.

 

You can move data from one field to another by using the drag handle next to the field in Widget Settings.

 

If you have mapped data from AnalytiX-BI, you can use the dropdown arrow next to a series to set or change its aggregate.

 

Note: Not all data can be aggregated in all positions. For example, you cannot aggregate data in the Category (X-axis) field of a categorical chart.

Change Chart Appearance and Other Properties

In the Appearance section of Widget Settings you can select a Palette of colors to be used to draw chart elements, such as pie slices or treemap squares.

 

Note: Changing the palette will override the colors of individual series for the categorical chart.

 

Note: At this time you cannot create custom color palettes.

 

The Format field sets the format for data labels.

 

The Labels option toggles the appearance of data labels. For the categorical chart, this option appears under the individual series.

 

The Legend section allows you to toggle whether the legend appears, and set its Position.

Using the Categorical Chart

Working with Multiple Series

The categorical chart can accept more than one series of data. To map additional series, drag additional tags onto the widget or the Value (Y-axis) field. If dragged onto the widget, the newly dragged series will appear at the bottom of the list. You can determine the order by dragging the series into the appropriate spot in Widget Settings, or reordering it after the fact using the drag handle .

 

To remove a series, select the X next to the series in the Value (Y-axis) section.

Change Chart Type (bar, line, area, etc.)

The type (such as bar, line, or area) of a chart is not actually a property of the chart itself. Multiple types can be combined into one chart, so the type is a property of the series. See the next section for information on how to change the series type.

Change Series Title, Type, or Appearance

Select your chart, go to Widget Settings, to Series, then select the series you would like to change. The different properties you can change are:

Combining, Stacking, or Clustering Series

Certain types of series, such as bar or area, can be combined in different ways.

When series are set as Stack or Stack100, there can be multiple stack groups. Enter the same string in the StackGroupKey field for all series you would like to be in that stack group. The exact string used as a key does not matter, but series with the same key will be grouped.

 

For example, the following figure illustrates four separate series, all set with a CombineMode of Stack. Two series have a StackGroupKey of One and the other two have a StackGroupKey of Two.

 

 

The figure below is the same four series, except all set with a CombineMode of Cluster.

 

 

The figure below is the same four series, except all set with a CombineMode of None. As you can see, some series are obscured entirely with this CombineMode because they are behind the other series. You can change the Z-order by reordering the series in the Value (Y-axis) list. You can also hide series to expose the ones behind by selecting their legend entry in presentation mode or toggling Visibility on the series properties in edit mode.

 

Configuring Multiple Axes

If you would like to plot different types of data on the categorical chart, you can add additional axes.

 

To do this, select your categorical chart widget, go to Widget Settings, then to the Vertical Axes section. Hit the + button at the bottom to add a second axis. To change the order of the axes, select the edit button, then use the up and down arrows. Use the - button here to delete axes.

 

To rename an axes or make other changes to it, make sure the edit button is not selected, then select an axis. From this page you can add a title and edit other settings, such as the visibility, color, and range. You can also change the side on which the axis is displayed by toggling the AlternativePlacement setting.

 

Once you have your axis created you need to assign a series to it. Go back to the main Widget Settings page for your chart, go to the Series section and select a series. For the VerticalAxis setting, choose your axis.

 

See Also:

KPIWorX Overview

Tables and Symbols as Dashboard Links