Hello,
A problem comes up when I tried to show a year on year growth rate on omniscope.
For my case, the sales data of different products are on the monthly basis. I did subset_sum on the product and yearly level, which could produce accurate result when I only select one product. But if I select more than one, the result is the weighted average of each product's growth rate rather than growth rate of the sum of the product sales over the year.
For example. Product 1, year 1 sales : 5 million kgs, year 2 sales : 6 million kgs
Product 2, year 1 sales: 4 million kgs, year 2 sales : 7 million kgs
the correct growth rate should be : [( 6+7)-(5+4)]/(5+4)= 44.4%
What the omniscope did: [ (6-5)/5 + (7-4)/4 ]/2 = 47.5%
I tried to apply weight on when showing the growth rate, but it still gets the discrepencies.
Is there any way to get round this problem.
Many thanks for the help!