color and cumul

[#1]

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?

[swuehl · Accepted solution]

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