Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need some expert advice on data representation relating to year over year growth.
Here is an example scenario
Customer | YR 2018 | YR 2019 | Change | % Change in 2019 |
A | 100 | 90 | -10 | -10% |
B | 100 | 110 | 10 | 10% |
C | 0 | 300 | 300 | |
D | 20 | 0 | -20 | -100% |
E | 100 | 100 | 0 | 0% |
F | 50 | 10 | -40 | -80% |
Total | 370 | 610 | 240 | 65% |
Even though there is 65% net increase in 2019 , the below chart gives an impression that 2019 is terrible . This is mainly because the value for C is missing ( for a valid reason ) .
So what is the ideal way to represent this chart to indicate that there is a significant growth ?or is there any way to indicate the zero to 300 growth for "customer C"
I definitely need the percentage . The above shown chart is part of my drill down. My actual scenario is much more complex than shown above.
Thanks,
Aji
If it suits your requirement and the business is ready for this you can do the following for c .
so if the denominator is 0 then mathematically the calculation is not possible.If you consider the zero to be it's next number that is 1 then change would be 300%. So if the business is ok with this you can write a condition like
if(YR2018 =0 , YR2019-YR2018 % ,Your_change_expression)
you can write something similar to above.