Attempting to get this graph to be a fully connect...
# gd-beginners
d
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.
m
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: https://www.gooddata.com/docs/cloud/create-metrics/maql/conditionals/ifnull/