Hi everybody, I’m attempting to get at % growth (Pre Vs Post implementation), so added a calculated filed percentDifference(({% Fale}),[{Classification} DESC],-1) but I’m not receiving the expected results. Could someone please assist me in cracking this?
Hello @sbaskax !
For your use case you might want to include a partition field at the end like this example: percentDifference(sum( {Billed Amount} ),[{Customer Region} ASC],1)
That being said, if you are doing a Growth% that compares a metric for a specific time, say July 28 and July 29th, you will probably want to use a parameter/filter to control the visual.
@duncan ,
Thank you for your reply, i have modified the calculated filed as
percentDifference((sum(fale)/sum(attempts)),[Revised DESC],-1), even then i am not getting the required output
Hey @sbaskax ,
To clarify, are you trying to measure the Growth% rate between two specific dates?
@ Duncan,
For your better understanding, I have week-by-week error% from weeks 1 to 28. I have calculated the average error% for both before (weeks 1 to 23) and after (weeks 24 to 28) the implementation of the incentive plan. I’m attempting to demonstrate the percent growth of the post introduction using these pre and post average error rates .
Hi , do i have any luck regarding my use case
Hello @sbaskax, you may be able to achieve the expected result if you partition by Classification. Maybe try something like this:
percentDifference(sum({fale%}), [sum({fail%}) DESC], -1, [{Classification}])
I hope that helps!