1 Reply Latest reply: Jan 6, 2016 7:40 AM by Sunny Talwar RSS

    Conditional Count Between Two Values

    Feras Alsuhaibani

      HI all,

       

      So I am new to Sense, and I have been playing with Sense's Desktop version. I have a question and I am wishing for your kind help.

       

      I have records and I want to classify how many records are finished with < 5 hours, between 5 and 10 hours and > 10 hours. Now I have been searching and I came across this method:

       

      Count({$<AccHoursDiff = {'< 5'} >} distinct ID)

       

      But my issue how can I modify this function so that I can satisify the second condition without having to specify the values i.e.

       

      Count({$<AccHoursDiff = {'5, 6, 7, 8, 9, 10'} >} distinct ID)



      Thanks!