drastic change in the behavior of an item in a chart Tendency

[#1]

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!

[swuehl · Accepted solution]

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

[#3]

WOW!!! amazing Stefan, that´s exactly what I need it, Thank you very much, I appreciate your help.