Gauge Maximum value consistantly set

[nat5]

How do I get it to read the data for the entire dataset (not just the lookup period), and set the maximum value to whatever the highest value is in the entire dataset and set this value to make it make sense each time no matter what timeframe you use?

[grant2]

Not sure how many years of data, but assuming 5Y is enough, you could do this:

[nat5]

I don’t want it to show the MAX value… I want the MAX value to be the upper end of the scale and for it to show the current value as the value of the bar and the value in the middle

[grant2]

AFAIK, you cannot dynamically set the max value. If you leave it blank, it will automatically set the max based on the time range selected. Or you can hard code it with a value of your choice.