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.
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
Hello @Lasya
Was @lary_andr’s comment helpful and if so could you mark their comment as a solution?
If you still need help with this, could you share the error you are getting from Quick Sight or how the calculation is incorrect?
Hello @Lasya
I am going to mark @lary_andr 's comment as the solution for now, if you still need help on this issue you can still comment on the topic.
Yes, the above statement worked! Thanks for the help