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

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.?

0 1 287
1 REPLY 1

Dawid
Participant V

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

Top Labels in this Space
Top Solution Authors