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.

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • We created a dates tables that we left join everything to in order to achieve this. There isn't another way that I know of. 

    Reply Like
Like Follow
  • 4 mths agoLast active
  • 1Replies
  • 105Views
  • 2 Following

Create A New Discussion

Share your thoughts