Week over week calculation error

Question & Answer
,
1

Hi,

I am trying to create PoP calculation and for some reason, the calculation is not working. Below is the statement -

difference( sum(numerator)*200000/sum(denominator), [{time_period} ASC], -1, [{period_type}, {network}, {metric_name}])

Just FYI, period_type contains ‘Weekly’, ‘Monthly’ breakdown and time_period contains the exact week or month details

Can someone please help here? Thanks.

2

Hello @Lasya hope this message finds you well!!

my suggestion to use difference is something like:

difference(
sum(numerator) * 200000 / sum(denominator),
[{time_period} ASC],
-1,
[{period_type}, {network}, {metric_name}]
)

please, tell me if it works for you