I want to build a line graph, and I have missing dates in my data. I would like to get value 0 for the missing dates.
With the option 'Show Missing values', all dates are showed in the graph. But the missing dates does not have any value but they appear and the line pass over them. Values for missing dates are not real NULL. And therefore, I think I can not use functions like IFNULL or ZN to transform NULL value to 0, because it is not a real NULL. Do you know how to solve the problem?