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={"Today()"},event_status_id={'31'}>}verification_time)

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

       

      If I write the date, it does work:

       

      Avg({<start_date={"11/22/2017"},event_status_id={'31'}>}verification_time)

       

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

       

      Thanks,

       

      Juan