How to change gauge needle color dynamically in a mini chart

[Anonymous]

Ideally I want the color of the needle to be red when the "vs Bud%" is negative and green when its positive. I did use calculated color for the needle. Not sure why it stays the same color for all three regions. Can someone help?

Thanks

[mikecrengland]

What did your expression look like? Did you use AGGR? Something like aggr(sum(sales),vsBud%)

mike

[Anonymous]

Thanks Mike.

My expression for the mini gauge column looks like this: =sum({<Scenario={'Act'},Region=>}Amount)/sum({<Scenario={'Bud'},Region=>}Amount)-1

The expression for the color is this: if (sum({<Scenario={'Act'},Region=>}Amount)>sum({<Scenario={'Bud'},Region=>}Amount),RGB(98,172,30),RGB(239,37,38))

I didn't use Aggr. How do I add it?

Thanks

[Anonymous]

Hey Mike,

I saw you offered some suggestions for this post. Would you be able to help me modify the expression so I can get my Gauge chart right?

Thanks!!

Zixiao

[mikecrengland]

Hello Zixiao -

Do you have a sample app that you can upload?

mike

[#6]

Hi

I'm dealing with the same problem

did you find any solution ?