15 Replies Latest reply: May 30, 2014 7:51 AM by Maarten Van Damme RSS

    Count #records between two periods of the day (time)

    Maarten Van Damme

      Hi,

       

      Does anyone know what is wrong with the following expression?

      =Count({$<[Incident creation time]={"<=$(=time(8/24))"}>} distinct [Incident ID])

       

      The goal would be to find the number of records that have been created before 8h00 (A.M). The chart return records, but definately not the correct ones...

      The ultimate goal would be to figure out how many records are present for which the creation time was either

      - between 00h00 AM and 08h00 AM or

      - between 06h00 PM and 24h00 PM

       

      Ps: I tried the set analysis builder but that didn't work out either (no records found).

       

      Any help would be appreciated.

      Kind regards,

      Maarten