How to use periodOverPeriodDifference with multiple aggregations

Question & Answer
,
1

Hi All,

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

Example

Capture
Capture846×311 19.5 KB

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

2

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

1 Like
3

@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.

4

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

thanks,

1 Like