Dynamic calculations / formulas for columns in dashboard / frontend

Question

We have a couple of customized KPIs that have different names and meanings for our customers. I want to compare two of those KPIs (aka columns or measures) to get the difference in percentage or absolute values. Two solutions to achieve this come into my mind:

1. When configuring the data source, add a formula to the ETL process that does the calculation between two values when importing the data

2. When creating a dashbord (or even when viewing the dashboard as a user), do the calculation dynamically by selection two columns or adding a formula that will reference two selected columns

Is there a way in Knowage to achieve the second one?

thanks!

Answer 1

Dear Nicky,

You can calculate the indicator using:

- SQL inside the data set you've created to design the cockpit

- Calculated field on Tabel Widget

Best Regards

A.

Comments

Thanks.. the second would be the preferred solution, as we want to be as much flexible as possible.