The KPI Dashboard – Evolved
1-877-233-6149
Contact Us

Displaying a sum or an average

Problem:

You want to display sum or average of the values in a column.

Solution:

Note: This article uses advanced features that are only available in the business version of Klipfolio Dashboard. Add <enterprise>true</enterprise> in your <setup> block in order to try them in Klipfolio Personal Dashboard.

Use the CSS property formula to display either the sum or the average of all values in a specified column. Note that type: number must be used for the columns for which you want to use a formula.

http://www.klipfolio.com/images/content/cookbook/formula1-a.png

Above example uses the following code:

oranges {
    type: number;
    itemcol: 2;
    noterow: 2;
    formula: sum;
}
apples {
    type: number;
    itemcol: 3;
    noterow: 3;
    formula: average;
}

The results are displayed at the bottom of that column. If the Klip is not tall enough to display all items, the results will still be displayed at the bottom of the Klip:

http://www.klipfolio.com/images/content/cookbook/formula1-b.png

Leave a Comment

To leave a comment, you must sign in or register (it's free).

   
Comment Type:
Title:
Comment: