Using your own formula and displaying its result

Problem:

You want to display the result of your own mathematical formula.

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.

You can generate content for a column using your own mathematical formula. For that column, you must use content: generated in addition to type: number and formula: <desired formula>.

For example, let's say you have some data on how many of your products were sold today and yesterday, and you want to see the increase in sales.

The above example uses the following formulas:

yesterday {
    type: number;
    itemcol: 2;
    noterow: 2;
    formula: sum;
}
today {
    type: number;
    itemcol: 3;
    noterow: 3;
    formula: sum;
}
increase {
    type: number;
    itemcol: 4;
    noterow: 4;
    content: generated;
    formula: "today-yesterday";        
}

The values under the "yesterday" and "today" columns came from a data source, while values under the "increase" column were generated using the formula "today-yesterday" as shown above. In the results area under store 6, "yesterday" and "today" columns show the sum of all values under each, and 42 is the results of "today-yesterday", or 187-145=42.