How to use periodOverPeriodDifference with multiple aggregations

Hi All,

do you know how to compute the periodOverPeriodDifference where there are multiple aggregations?


Formula used
periodOverPeriodDifference({[%] Metric Value},{[date] calendar week date}, DAY, 364)*10000

You can look to make it an not aggregated calculation by adding PRE_AGG or PRE_FILTER.

1 Like

@Max thanks, can you provide a quick example on how would you do it? I tried, but I cannot properly figure out how to do.

Solved! sumOver(periodOverPeriodDifference({[%] Metric Value Total Website},{[date] period date WMQY}, DAY, 364)*10000,[{[date] period date WMQY}])


1 Like