Displaying active records over time

Hello Gliders,
So I have a spreadsheet which shows subscribers start date and end date (if they cancelled subscription). I want to build a report which will show all active subscribers at any given date. Has someone done this already and can you point me to resources?

I know it will take some tinkering around with the google sheet and some cleverness in the data editor. Any help or insights are appreciated.

Thankyou very much in advance.

No tinkering required in the Google Sheet.
Let’s say you have 3 columns:

  • Start Date: Subscription start date
  • End Date: Subscription end date
  • Date: the date you’re interested in

In the Glide Data Editor, create an if-then-else column:

  • If Start Date is after Date, then false
  • If End Date is empty, then true
  • If End Date is before Date, then false

The rows that have true in that column will be the ones that were active as of “Date”

1 Like