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!