Dynamic Date Ranges for KPI Current Sales and Previous Sales

[duncan]

Hello @Purushothaman

I would recommend checking out this topic with a similar need:

Create a KPI visual that compares to the previous period

Hi, I have a report where the user can select a date period and see metrics. It contains several KPIs that show the sums of the metrics within that period. I also want to the KPIs to calculate the percent difference compared to the previous period. Essentially, I want a calculated field that calculates the value of the previous period and use it as the target value of the KPI. The period should be dynamic based on the date period the user has selected. So, if the user selected a week in the d…

There is an arena link with an example of how to make this work.