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