Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a chart with the dimension Year and Expression Sum(Profit).
How do I write an expression to check if the profit for one year has increased or decrease since last year?
In other words, profit Year X is larger than profit Year X-1. I know it's possible to call the variable Year but not how to compare it with another Year variable...
use function above() to get the previous value - if you chart dimension is "Year", then the previous value will be the value from the previous Year.
Hi Oleg,
This does indeed work, but for me sometimes it does not...
Attached I created an example for which the above function only displays a '-' ...
Very strange... but probably for a reason 🙂
Regards,
Maarten
hi,
this is because you are using several dimensions in your charts.
In this case you must use the function above() with the qualifier TOTAL. like this
above(total aValue)
Hi,
Thanks! That did indeed fix it!
10Q!
Have great day!
Maarten