Flexible metric comparison

I have a list of metrics, that i would like to be able to compare to previous periods in a flexible manner. As far as i am concerned the trend group field is static so that it will only compare to the period you have preselected and is not changable in the dashboard.
I would like to be able to create a flexible options, so that when i show the metric for say this month, it will compare it to the previous one. Similarly if the last 90 days is selected it will compare the metric to the previous 90 days.

Has anyone had some luck building something like that or know that it is possible?

Hi @kkpmany - please refer to this thread: Need help to replicate Year over Year - when KPI is a calculated field

It also points to the Demo Central link: https://democentral.learnquicksight.online/#Dashboard-TipsAndTricks-Calculation-Year-over-Year-KPI. If you open the analysis (edit icon in the left menu navigation) in the demo central, you can refer to the calculated fields (Prior Period, Selected Period) and how they are used with the Parameters.

Let us know if it helps. Thanks!


Hi @kkpmany - Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!

1 Like