4 Replies Latest reply on Jul 12, 2017 6:20 AM by Arthur Tang

    How to get counts of active enrollments (active between two dates)

    Nick Cheng

      I am new to Tableau so apologies if I am misunderstanding something. I have a set of course enrollment records (1 row per enrollment) where each has an enrollment date and some have withdraw dates. I'd like to be able to get a graph of active enrollments (enrollments are active between the enrollment and withdrawal dates) over time. How can I do this WITHOUT creating a calculated field for every day in my dataset (e.g. Active on Day MMDDYY)?

       

      Thanks very much for any guidance anyone can provide.