malloy icon indicating copy to clipboard operation
malloy copied to clipboard

Include dates with no values in charts

Open carlineng opened this issue 7 months ago • 0 comments

From @bporterfield:

I'm having trouble with charting and sparse data - I want to show a chart of usage across days, but using the bar chart tosses out the days that don't have data.

Here is the bar, which gives me accurate representation of the sparse usage except it skips days where there is no data, so glancing at it without paying very close attention to the X axis gives you the wrong impression

image and i’m savvy enough to know how to fill the empty dates in sql with zeros but would be rad if there was easy malloy or malloy charting way to do that

carlineng avatar Jul 11 '24 18:07 carlineng