Color Agent - comparison to dimension


I am trying to color the measure value below for each week based on the previous week. If week 34 is higher/lower/neutral vs week 33 I need to color green/red/black respectively, and week 33 vs week 32 and so on. Trying to show the positive/negative growth without creating a difference column. Can anyone help?

What would be the syntax for the color agent condition in this scenario?

Each row of data represents a brand, and the weeks are a single user dimension with 8 members. 




1 comment
  • Hi,

    please try the condition value > sum(-1, 0, m1) to compare with the previous column.


Please sign in to leave a comment.

Didn't find what you were looking for?

New post