4 Replies Latest reply: Nov 22, 2017 4:21 PM by Juan Moreno RSS

    Today() in Set Analysis

    Juan Moreno

      Hello all,


      This should be an easy one, but no matter how I write the Today() condition in this set analysis expression, I end up having a blank chart: I want to show the average verification time for events with a certain status (31) and that started today.


      I've tried several alternatives, with no luck:



      Avg({<start_date={$(=Date(Today(), 'MM/DD/YYYY'))},event_status_id={'31'}>}verification_time)


      If I write the date, it does work:




      Any idea on what might be wrong with Today()? This seems like a syntaxis issue, but I can't see what the mistake is.