Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can anybody explain me why calculations from my bar chart are different from what i excpect to see ?
I want to see current difference between years in accumulation mode. Value is correct only for first quarter.
Example application in attachment. Any suggestions are welcome!
Thanks, Piotr
I've found solution - more complex but working.
I disabled accumulation option for all expressions and use Above() function to accumulate values in the same way.
I think that accumulation option caused the problem, because calculation of expression was performed for every value of dimension (Q1, Q2..) and the results were summed.
Expressions are not so simple as it could be using accumulation mode in chart, so if somebody know simpler solution (simpler expressions or other solution) to obtain such an effect as above, please let me know.
File with my solution in attachment.
Regards, Piotr
Hi buddy,
I guess that your informations are accumulated.
Look on graphic properties - expression - Accumulate (on down and left of window).
bye
Yes, it is accumulated because I expect this kind of analysis, but %Change is not correct.
In Q2 it should be 34,09% instead 68,33%.
If I uncheck accumulation I would see only comparison of single quarters, but I need comparison of accumulated data.
Regards,
Piotr
I've found solution - more complex but working.
I disabled accumulation option for all expressions and use Above() function to accumulate values in the same way.
I think that accumulation option caused the problem, because calculation of expression was performed for every value of dimension (Q1, Q2..) and the results were summed.
Expressions are not so simple as it could be using accumulation mode in chart, so if somebody know simpler solution (simpler expressions or other solution) to obtain such an effect as above, please let me know.
File with my solution in attachment.
Regards, Piotr