Color Agent - comparison to dimension
Hi,
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.
0
Comments
Hi,
please try the condition value > sum(-1, 0, m1) to compare with the previous column.
Please sign in to leave a comment.