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.

       

      Thoughts?