Force 0 on Continuous line chart when expression is Avg( )

[MattG]

Hi all,

I have a line chart over a continuous x-axis that I want to drop to zero when no data exists for that time value.

If my query is a SUM, then this is fine by using  + SUM({1}0) 

My problem is that for this chart I am using an AVG function.

I've tried +AVG({1}0) but this didn't work. 

Has anyone found a solution to this problem before?

[marcus_sommer · Accepted solution]

You may try: rangemax(0, avg(FIELD))