Gauge chart

[#1]

I like to modify the gauge chart in the example i attached.

I try to introduce some data limitation, but they not work.

please could you help me. thanks

[#2]

you are right, the correct formula is

=num((SUM({<Year = {$(=Year(Today()))}, AlsisScope = {'G','J'}>}CountOrder)/2000),'###0%')

but the indicator not move, it is posted on 0 yet

the indicator should be in yellow area therefore 23%...

please what could be the issue here instead?

[Anonymous · Accepted solution]

The same expression still needs to be inside the actual "Definition" make sure that you also have corrected this expression.

.