Forcing X-axis to populate missing dates
Hello Domo people,
I’m trying to display data from JIRA in which the X-axis is a series of dates. However there are several dates which have no data and as a result do not appear in the Domo data set.
I’d like to include days that have no data so that the timescale is consistent. Is there a way to do this easily in Domo? I didn’t see any options in the chart properties. Perhaps if Domo recognized the values as dates it would fill the missing values in?
Would you recommend doing this with a dataflow? I've been playing around with some SQL statements, but it doesn't seem like a good fit.
I could do it easily as a one-off in Excel but as this JIRA data is dynamic I would prefer to keep the graph display dynamic as well.
Thank you for your help.