Select filters with Gauge Chart (Text)

[#1]

Hi,

can I select the filters in a Gauge Chart, like in a Bar chart?

I mean, I have a gauge chart (the text one, that only show a green big number). What I want is when I pressed on it, automatically select the possible values in the filters above, as it happens when selecting in a line or bar chart.

Thanks in advance.

[#2]

I attach a file which shows the problem.

• If I select, Madrid, the gauge shows 2.
• If I select, Salamanca, the gauge shows 0.

What I want, is when I click the gauge chart, it only select, in this case, Madrid

Script file:

Region:

load * Inline [

idCompany, Region, isInstalled

1, 'Madrid', 1

2, 'Madrid', 1

3, 'Madrid', 0

4, 'Salamanca', 0

];

And expression in gauge char:

sum(isInstalled)

In the file, if i click on the bar chart, it select the correct regions, but gauge chart, is not working properly.

What I'm missing?

[michael_maeuser]

see attached

[#4]

In the example it is valid, but I have more filters (company, dates...) so that approach is not going to work on my project. I can't maintain a new column, for each possibility.