How to use Mini Chart formats


Overview Create successful Mini Charts that show trends over time by formatting your data as a comma separated list. You can do this using one of two functions:
JOIN function
CONCAT function
Mini Chart formats Bullet Charts
Horizontal Mini Charts
Spark bars
Win/Loss Charts
Components that support this feature: Table component
Value component
Sparkline component
Label component


Mini Charts show trends over time. You can use Mini Charts in Table, Value Pair, Label and Sparkline components, provided that the data is formatted as a comma separated list. If it is not, you can format it using the JOIN function or the CONCAT function.

This image shows raw values and three Mini Chart formats:

To create a comma separated list (JOIN Function)

If the values in your data source are in adjoining cells (A1 | A2 | A3), then use the JOIN function to create a comma separated list.

JOIN ("A1:A3") returns (1, 2, 3)

To create an array of comma separated lists, wrap the JOIN function in an ARRAY function.

ARRAY (JOIN ("A1:A3"), JOIN ("B1:B3"), JOIN (C1:C3))

To create a comma separated list (CONCAT function)

To create a comma separated list for an unbounded range, such as A:A, use the CONCAT function. Optional: If your data source has a header, use the SLICE function to remove it.

CONCAT ("A:A") returns (1, 2, 3, 4, ...)

To create an array of unbounded comma separated lists, manually insert a comma between data selections.

CONCAT ("A:A",",","B:B",",","C:C") 

Learn more:

Now that you know more about Mini Chart formats, check out these tutorials:

Important concepts

These articles provide an overview of important concepts for building Klips:

Feedback and Knowledge Base