Given the following example table below, how can I calculate the growth or decline at the manager level dynamically using a dashboard calculated field? Also, How can I display the results in a dashboard KPI?
To calculate the Growth or decline I need to use the following formula:
and here is an example of how I solved the problem the problem on e-paper :
Based on my paper solution, I then tried to replicate the logic in QuickSight using the sumOver() function and parameters ( start_date / end_date, manager).
My goal is to use the two variables as the source for my KPI.
But, when try to create the KPI using the two variables no data is displayed. How can resolve this issue?