Data Studio
3.7K members online now
3.7K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Add/Drop Reporting

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

If enrollment records in a Gsheet have an "added" date and a "Dropped" date can I show active enrollments by date?

Cumulative count of records added up to a date excluding those with a prior dropped date

Add/Drop Reporting

Follower ✭ ✭ ✭
# 2
Follower ✭ ✭ ✭

You can apply a filter specifying to only show those where "Dropped" is empty or null (depending what the system read as).

 

 

Add/Drop Reporting

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

That sort of works, but in the cumulative time series an enrollment is supposed to count if it is after its added date but then not be counted after its dropped date. The filter would just remove it from the time series altogether - no?