I have an Gauge Chart whiche works. I have some datas which are 0.00 and it would be great if the chart ignores the 0.00 that it does not pushing down the avg. The Expression is Avg(Value).
Try an expression that tests for Value not being 0. Something like:
... or using an if statement ...
I tried the first expression, it didn't worked. It showed nothing.
With Avg(if(Value<>0, Value)) it workes fine.
And also thank you for the fast answer
Try this if you dont want the If-statement.
Retrieving data ...