Displaying active records over time

Ask for Help
1

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

2

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