Attempting to get this graph to be a fully connect...
# gd-beginners
Attempting to get this graph to be a fully connected line graph to show the 0 values when there is no data for that day. How would I go about doing this? I see the Continuous Line option but that only connects the points which is not showing the 0 value. I drew some fake red lines in to give an idea of what I am talking about.
Hi Drew, in such cases you can use the IFNULL function: IFNULL statement allows you to control replacement of missing values that are returned by an expression. If a metric expression that is wrapped within an IFNULL statement ever returns a null value, the replacement number specified in the second parameter of the IFNULL function is inserted in place of the null value. More details can be found here: