Displaying values as a column chart

Problem:

You want to display data as a column chart.

Solution:

Example Klip

Download the sample Klip for examples discussed below.

Important Notes

• Column charts are supported in Klipfolio Dashboard version 5.4 and above.
• Depending on the version of Klipfolio Dashboard you are running, the data source from which the chart is generated can be in one of the 2 formats. See the Expected data format article for details.

Overview

• Use type: graph and format: "column" to generate a column chart. (See example 1)
• Add threshold(x) to display any values above the supplied threshold value x in a different colour. (See example 2)
• Add refline(y) to draw a horizontal line at y as a reference line. (See example 3)
• Add refband(<integer1>,<integer2>) to draw a horizontal band spanning from integer1 to integer2. (See example 4)
• Add period(<integer1>,<integer2>) to draw a band from the beginning of the period specified with integer1 and ends at integer2. (See example 5)
• The default height of the chart is height: 1, which is the height of one line. The height may be set to 2 or 3 to span 2 or 3 lines within each item, respectively. In the screenshots below, height: 2 is used.
• The colours are predetermined by the skin and its hue and cannot be specified through the Klip.

Expected data format

See the Expected data format article for details.

Examples

Regardless of how the data source is provided to the chart, the available formatting options are the same.

1. Simple column chart

type: graph;
format: "column";

2. Specifying a threshold

format: "column,threshold(50)";

3. Specifying a reference line

format: "column,refline(50)";

4. Specifying a reference band

format: "column,refband(50,80)";

5. Specifying periods

format: "column,period(0,3,9,12)";