Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a metric with full accumation option. I would like change the color if the value it's the first one after a target
for example:
dimension metric cumul
A 10 10
B 5 15
C 6 31
D 4 35
If my target is 30, I would like display C - 31 in color.
I tried to do that with visual cues and background color.
for the background, that's take the formula but not the accumuation.
Have you got some ideas?
You can use background or text color attribute expressions for this. Go to the expression tab and open the attributes by clicking on the small plus sign. then select the background color and enter something like
=if(Dimension= min(total aggr(if( rangesum( above(100/Count(total Metric)*Count(Metric),0,rowno()))>70,Dimension),Dimension)), lightred())
To color e.g. the line that shows a cumulative percentage >= 70 % in your previous sample file.
Hope this helps,
Stefan
You can use background or text color attribute expressions for this. Go to the expression tab and open the attributes by clicking on the small plus sign. then select the background color and enter something like
=if(Dimension= min(total aggr(if( rangesum( above(100/Count(total Metric)*Count(Metric),0,rowno()))>70,Dimension),Dimension)), lightred())
To color e.g. the line that shows a cumulative percentage >= 70 % in your previous sample file.
Hope this helps,
Stefan