Gauge Chart - Change colors depending on characteristicas

Manuel174102 — Tue, 02 Aug 2022 12:22:53 GMT

Hello.

I have a gauge chart which I divided in three, red,yellow and green.

I am selling this pieces, I have the goal and also the real sells. I want to paint it based on if I sell more than the goal or not.

But I also have to keep in mind if I select two of the pieces, I also want to apply color to the combination.

How could I do that?

For example for piece 1 I would paint it yellow, piece 2 green, piece 3 red but piece 1 + 2 it would be green.

Re: Gauge Chart - Change colors depending on characteristicas

justISO — Tue, 02 Aug 2022 12:34:10 GMT

Hi, have you tried

sum(Real) - sum(Goal)

Manuel174102 — Mon, 08 Aug 2022 08:36:01 GMT

yes, but it didnt work 😞