3 Replies Latest reply: Mar 6, 2018 3:53 AM by Pablo Labbe RSS

    Expression inside Set Analysis

    Mark Ritter

      I want to do a calculation (AVG) based on a date falling in a certain date range.

       

      I tried something like this and this works. Attempted to calculate the metric for records that fall in the past 90 days.

       

      =avg( {<CalendarDate={">=12/03/2017"}>} ($(vCheckinTime))*1440)

       

      But I have to hard code the date that is 90 days ago. 

       

      I tried to replace the hard coded date with today()-90 but I get no results.

       

      Is this even possible in Set Analysis?  If it is what should the syntax be?