The Combo visualization makes it easy to build quickly a comparison visualization without having to build a table first. You can easily view trends in your data in a line/bar combination.
Use a Combo to:
Keep in mind that:
Add a Combo visualization. See Add a visualization to a panel
From the drop-down lists, select a dimension for the X-axis and a metric for the Y-axis.
Select the type of Line comparison that you want to use.
Line comparison type | Definition |
---|---|
Time comparison | The most common type of comparison - comparing this time period to 4 weeks ago, for example. If you selected Time comparison, make a secondary selection as to which time period you want to compare. |
Function | You could introduce a function like Average into the comparison. See the list of supported functions. |
Secondary metric | You could, for example, compare Revenue to another metric. |
Select Build.
The output looks similar to:
The current period is shown in the bar chart. The line chart represents the comparison period. The dots on the line chart are known as bar bells.
If you select Function as the Line comparison type, a function of the metric chosen is returned.
Function | Definition |
---|---|
Column Sum | Adds all numeric values for a metric within a column (across the elements of a dimension) |
Cumulative Average | Return the average of the last N rows. |
Median | Returns the median for a metric in a column. The median is the number in the middle of a set of numbers. Half the numbers have values that are greater than or equal to the median, and half the number have values that are less than or equal to the median. |
Cumulative | The cumulative sum of N rows. |
Column Maximum | Returns the largest value in a set of dimension elements for a metric column. |
Mean | Returns the arithmetic mean, or average, for a metric. |
Column Minimum | Returns the smallest value in a set of dimension elements for a metric column. |
Here is an example of the cumulative average of the Revenue metric:
Here is an example of a combo chart with both Cumulative average and Mean functions: