How to build Table components


Component Table (Columns)
Overview The Table component is the most flexible visualization in Klipfolio, and can be used to display raw values, mini-charts (like sparklines), indicator images, and more. Each column in the table can be customized to display data exactly how you want.

Important: for performance reasons the number of rows displayed on the dashboard is limited to 200.
Key Features

Customize column headers with display properties, formulas, and indicators.
Apply indicators to any column
Add a results row sub-component to summarize a column of data
Use mini-charts to add visual elements to your table


The Table component is the most flexible visualization in Klipfolio, as it can be used to display values using a wide range of formats. You can use the Table component to display raw values, percentages, currencies, mini-charts like sparklines and bullet charts, images, hyperlinks, and indicators. Here is an example of table that uses a few of these features:

Component Structure

This is an example of the structure of the Table component with a custom results row.

Key Features

This section provides examples of different ways to use the Table component.

Customized Column Headers

You can apply display properties, formulas, and indicators to individual column headers for Table components by selecting the Use custom header option in the Klip Editor. This enables you to customize your column header independently from the rest of the data in the sub-component. For example, select the Data tab and type a formula for a dynamic column header: DATE_CONVERT(DATE_UNITVALUE(TODAY(),month),"M","MMM")

This formula displays the current month using the TODAY and DATE_UNITVALUE functions in a specified format using the DATE_CONVERT function.


Applying indicators to any column in your Table component can help provide additional context for the value being displayed. You can use the Indicators panel to change the color of values, assign an icon to the value, or color the background of cells to create a heatmap.

To apply indicators

  1. Select the component to which you want to apply the indicators.
  2. Open the Indicators panel.
  3. Set up a predicate (eg: If x is greater than 1).
  4. Set up a reaction (eg: then change the colour to green).
  5. Add multiple conditions to apply indicators for values in a variety of states.

Results Rows

Results rows can be used at the bottom of any column to provide additional insight. Results rows can use one of six mathematical functions (SUM, AVERAGE, COUNT, MIN, MAX) or use a custom equation. The image below shows three results rows that use the AVERAGE function.

To add a results row using the math options

  1. Select the Column component to which you want to add a results row.
  2. Open the Properties panel.
  3. Select one of the math options from the Results Row menu.

A results row will be added to your column

To add a results row using the custom option

  1. Select the Column component to which you want to add a results row.
  2. Open the Properties panel.
  3. Select the Custom option from the Results Row menu. A new sub-component is added to your column in the tree.
  4. Select the Results Row sub-component.
  5. Assign data to it as you would a column component.
  6. Optional: Apply indicators and adjust properties as needed.

Using the mini-chart format

The mini-chart format lets you show spark lines, spark bars, win/loss charts, and bullet charts in your table's columns. It's important to note that in order to use a series of values for use in the mini-chart format, they need to be formatted as a comma separated list. This can be accomplished using either the ARRAY and JOIN functions or the CONCAT function.

Learn more:

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