Create "empty" date series in explore for filtering other measures

  • 7 January 2022
  • 1 reply

Hello, I have an accounts table that has a signup date and a cancel date.  I want to see total amount of active accounts on particular months to create a visualization.  Each account will have multiple months of being active defined by the start and end date.  How do I make a date column for the X column that wont filter the results?  As in, a date column that is not based on any attribute of the accounts that I can compare fields against.?

This topic has been closed for comments

1 reply

Userlevel 7
Badge +1

You need a table that contains all the dates. Whether you call it a date dimension or calendar, and then you’ll have to join it to create a table where unique key is no longer just account_id but acount_id + date