Max Value for Gauge settings gives error message when select on Dimension

[Anonymous]

I have a chart with 5 linear gauges and it works fine.  However, when user selects on the only Dimension in the chart (Agent Name) and if the value for the expression is 0 then the Linear Gauge displays ‘Bad Min or Max Value in Gauge’.  I would expect that the Linear Gauge would show nothing.

Here's example when user selects on Agent Name that has 0 values for 3 expressions.

Here's the settings for the Linear Gauge chart:

Max value is set to formula: max(aggr(sum({$< AgentLoginID-={'none'} >} FlagFUFax), AgentNameLastFirst))

How do I get rid of the message '‘Bad Min or Max Value in Gauge’ from displaying in my chart?

[johnmahoney]

Hi

I happens when your calc =0, so edit your max value with an if statement

If(max(aggr(sum({$< AgentLoginID-={'none'} >} FlagFUFax), AgentNameLastFirst)) = 0,1,

max(aggr(sum({$< AgentLoginID-={'none'} >} FlagFUFax), AgentNameLastFirst)))