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?