Please enable JavaScript to view this site.

thankQ Help

You can also compute values of calculated fields on a visualisation (or summary) level. In this case, the Dashboard computes calculated field values using displayed data.

The underlying data source below contains the Profit and ExtendedPrice fields.

TQDASH~1_img62

If you want to calculate a margin, you need to divide the sum of Profit values into the sum of ExtendedPrice values. To do this, you can use the set of aggregate functions (Sum, Min, Max, etc.) that allow you to perform calculations on a visualisation level.

TQDASH~1_img63

In this case, a calculation is performed after an aggregation.