Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All, I have a really doubt,
The question is, is there any way to identify the Items (No.Material) or the month with the most drastic change behavior in a chart tendency?
I attached a print screen and the app for a better understand!
I´m really lost of how to get this, any help woulb be great!!
Thank you all!
You could detect changes and color the cells using the background color attribute expression. For example, I used
=if( fabs(("Total Roll Up" - before("Total Roll Up")) / "Total Roll Up") > 0.5, Yellow())
to detect changes > 50%. Please see attached.
(To see the background color attribute, open the expression attribute on expression tab using the plus sign next to expression label in box at the left upper side).
Hope this helps,
Stefan
You could detect changes and color the cells using the background color attribute expression. For example, I used
=if( fabs(("Total Roll Up" - before("Total Roll Up")) / "Total Roll Up") > 0.5, Yellow())
to detect changes > 50%. Please see attached.
(To see the background color attribute, open the expression attribute on expression tab using the plus sign next to expression label in box at the left upper side).
Hope this helps,
Stefan
WOW!!! amazing Stefan, that´s exactly what I need it, Thank you very much, I appreciate your help.