GROUPBY can be used to format your data in a comma separated list to use those values in a spark line, spark bar, or win/loss chart. This is useful for aggregating multiple unique elements in your data source and then plotting them using one of the mini chart formats.
GROUPBY( values1, values2,"method" )
-
values1: set to the Regions data in column A (
A:A). -
values2: set to the Units data in column B (
B:B). -
method: set to
"join(values)".
To create a sparkline, spark bar, or win/loss chart:
- In an open dashboard, click the +Add Klip button.
- Click the Build a custom Klip button.
- Select the Table component.
- Click Add Data Source and select an existing data source from the list.
- In the Component Tree, select a Column.
- Select the Data panel and apply the GROUPBY function in the formula bar.
For example,GROUPBY( values1, values2,"method"). - Select the Properties panel.
- At Column Header, type a name for your column.
- At Format as, select the appropriate mini chart. For example, Mini Chart: Horizontal.