Period over Period Percentage Change

[Andrew]

I want to create a dashboard that gathers the data from one date and compare the difference (in percentage) with another date. For instance, if you choose October 1 and October 15, the dashboard will show you that the data increased by 10% in that time frame.

I know this exists in Insights, but I am only able to get this data from the current day against the previous day. In terms of Insight, I want to be able to change PeriodOverPeriod.previousTimeValue.formattedValue to the date that I select via a date picker in the dashboard and thus, that will change the value for PeriodOverPeriod.previousMetricValue.formattedValue and compare it to PeriodOverPeriod.currentMetricValue.formattedValue. Does anyone know how to calculate this? I am also open to other solutions!

[Prachi]

Please check below link:

Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 90 days, etc)

Often you may want to create tables and other visuals which display multiple fields that are all ‘filtered’ to different date periods, as well as period-over-period fields. However we can’t use normal filters for this since filters get applied to all fields in the visual. Conceptually in this solution we are building the filters directly into the calculated field itself (using the ifelse logic), so that each field can have a different ‘filtered’ time period. You can then do whatever math you wan…