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