I have a dataset that has subscription data (Id number, Start Date, End Date) and I need a way to see how many are active on any given date.
A line chart with the date on the X axis and a Distinct Count of the ID as the Y axis would be my preferred visualization. Using start date or end date as the x axis does not work though.
I can't just join the data set to a daily calendar because that would be way to many rows.
Any one have any ideas?