Straight table measure limit icon

Love_S — Sat, 14 May 2022 11:21:04 GMT

Hi..

I have an issue that I don´t understand, and I hope someone can help me.

I have a straight table with one dimension and two measures (last and second last month).
I´ve added the measure for second last month as the limit for the last month. I want the icon to be green if last month is higher that the second last month, and red if it is lower.

The strange thing is that it shows correctly for some dimensions, but not for all.

The values are correct, but the icon is incorrect.

In the image below the value for APAC is higher in 2022-04 than 2022-03, but still the icon is red.

The master item measure for 2022-03 is also the used as the limit for 2022-04.

Any tips on how to proceed or how to find out why this is happening?

Thanks a lot....

Re: Straight table measure limit icon

vinieme12 — Mon, 16 May 2022 07:21:33 GMT

Indicator will evaluate against only ONE VALUE for all rows in the entire chart ONCE, it does not evaluate a limit value per row

therefore using indicators would not be possible, you can still use background color expression though

=if(expressionfor2022>expressionfor2021, green(),red())

topic Re: Straight table measure limit icon in App Development

Straight table measure limit icon

Re: Straight table measure limit icon