Average Reference Line - does not take null values into consideration

[lior_eliyahu-16]

Hi, 

I was using the ‘fill in missing dates’ feature on my graph in order to have a trend line of our metric, and then when I wanted to see the average of all my observations (I’m using also a date filter) I saw that there is a mistake because the average does not take into consideration null values on the calculation. 

I know I can solve this issue quickly by using COALESCE(X,0) but this will impair my drill fields, because a table calculation does not have the ability to drill fields from what I saw.

Any help/ideas?

Thanks in advance