Hi
How can I add a row like the following to do a difference of multiple metrics(not just one metric/value) in QuickSight?
You need to make a calculated field for each metric. You can you the period over period difference function for each column.
However, this won’t get you a new row. It will give you more columns. In order to get a new row, you would need to use SQL. Calculated fields create columns, not rows.
Thanks Max, I realized for Level Aware calculated fields I need to use difference() as periodOverPeriodDifference() may not work.
1 Like