Color agent based on measure values

Glenn van Herten

October 27, 2021 09:01

Hello,

Would it be possible to base color agents based on measure values? For example, I have a table with Column A(measure 1) and column B(measure 2). I want to add a color agent to show an arrow whenever the value of measure 1 is above measure 2. I know I can add a custom calculation to calculate the difference, and base the color agent on that. But I want to add the color agent in column A.

Would this be possible?

Comments

5 comments

Kristoffer Drejer
October 27, 2021 09:29
Yes,

You create a color agent on measure1 with code
```
Value > sum(d1,0,m2)
```
Alternatively I like to specify what is happening in the color agent by naming the references like this:

If for instance m1 was YTDSales and m2 is YTDLastYearSales
```
YTdSales:(sum(d1,0,m1)) > YTDLastYearSales:(sum(d1,0,m2))
```
0
Michael Skals
February 10, 2022 09:13
This works for me but not if I have more than one month like in this example. I would like November to be green...

I probably have to modify the code, but how?
```
Value > sum(d1,0,m2)
```
0
Ole Dyring
February 10, 2022 13:03
Hi Michael,

Try with
```
value > sum(0, 0, m2)
```
BR / Ole
0
Michael Skals
February 15, 2022 14:23

Great Ole, thank you. That worked wonders for me...

But now another problem has occured. Apparently these codes aren't my best asset ;-)

I have an almost identical task here so I thought I was able to use the same code.

I want a color agent showing whether the January result is better or worse than the target of 93,0

The difference to the last task is that "Mål" is a calculation and not a measure. Maybe that makes a difference to how the code should appear?

I get this error when trying to apply the code:

0
Louise Stub Hansen
February 15, 2022 15:01

Hi Michael

If it is a calculated column you need to refer to it as c1, c2, c3 etc. instead of m1, m2, m3.

So the syntax might be: value > sum(c1,0,m1)

If you click at "Advanced calculations":

And try to make a new calculation, you can click at the column/measure you want to refer to. Then you get the correct syntax. And then you can use this syntax in your colouragent. (and just delete the new calculation again)

0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post