5 Replies Latest reply: Feb 22, 2017 11:21 AM by Michael Goldshteyn RSS

    Finding average days between two dates

    Michael Goldshteyn

      Greetings Community,


      I have a set analysis to find the average days that students are on the waitlist for a course.


      Course being my Dimension, and "Average Days on Waitlist" being my Measure.


      My code for the Measure looks like this:

      avg({$<transcript_status_code = {'W','w'}>}(date(today() - waitlist_date)))


      I am having trouble building the code to show only the course(s) that have less then or equal 100 days.