Forum Discussion
Understanding Context Between Average and Sum - Remove Filters
Hi, Anonymous
Is this what you want?
I didn't do much correction, just divide the two measures you've created.
Avg2. % Pay Changes = DIVIDE(HRIS_TD_COMP_BY_NETWORK_SUMMARY[Sum % Pay Changes],[# of EE Receiving Pay Changes])Best Regards,
Community Support Team _ Eason
" A got 2 pay changes (11.1 % and -10%) so effectively he got 1.1% pay increase"
Not really. Let's assume A starts with 100. 100 x 1.111 x 0.9 = 99.99 . He got a decrease, not a raise.
You are absolutley right. We are having internal discussion about exactly this topic. My question is: if we go through this use case, then how can we achieve the desired result? Thanks!
I would start with a better definition of the business problem - what issue are you actually trying to solve?
Then I would cleanup my data, and provide good timestamps
Lastly I would work with the business users on the UX. They often cannot articulate well what they want but when you show them a prototype they can quickly tell why what you did is not what they wanted. After a couple more iterations you will hoepfully arrive at an acceptable solution.
The first step is absolutely crucial.
Hi, Anonymous
Is this what you want?
I didn't do much correction, just divide the two measures you've created.
Avg2. % Pay Changes = DIVIDE(HRIS_TD_COMP_BY_NETWORK_SUMMARY[Sum % Pay Changes],[# of EE Receiving Pay Changes])Best Regards,
Community Support Team _ Eason