Filter Guage chart color from a Pie chart

[Anonymous]

Hello,

I am having a problem with filtering a Guage chart and a Pie chart. The 'Picnic' pie chart contains three parameters. I want the 'Displayer' guage chart to always change such that:

when the color on the pie chart is both Green and red, the guage chart should be on the red side

When the color of the pie chart is green and yellow, the guage chart should be on the yellow side.

when the color on the pie chart is yellow and red, the guage chart should be on the red side.

when the color on the pie chart is green, the guage chart should be on the green side

when the color on the pie chart is yellow, the guage chart should be on the yellow side

when the color on the pie chart is red, the guage chart should be on the red side

Thanks.

[MarcoWedel]

can you show how the result should look like in those different cases?

[Anonymous]

Thanks.

First case: When the color on the piechart is yellow and green, the Guage chart should be on the yellow as shown.

Second Case: When the color on the piechart is red and green, the Guage chart should be on the red as shown.

Third Case: When the color on the piechart is red and yellow, the Guage chart should be on the red as shown.

Fourth case: When the three colors are present on the pie chart, the guage chart should be on the red.

Thanks.