Adding in missing dates for charts
Say you're charting a metric per day (i.e. y-axis: sum(foo), x-axis: date). When displaying bar charts for this metric, there are often no entries for things like weekends. If there's no entry in the table for a certain day, then Mode's Chart doesn't show that x-axis entry.
Is there a way to graph days with 0 for the metric? Either through an option while charting (i.e. "show all days even with no metrics") or via the table data. Via table data I've researched solutions that call for selecting from a calendar table or something similar (i.e. "select CURRENT_DATE - X as Day, 0 as Metric") and joining that table with the results table. However as far as I can tell, Mode has no calendar data to select from.