How to see active subscriptions without copying rows?
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…