4 Replies Latest reply: Aug 27, 2015 2:24 PM by Krishna Chaitanya RSS

    Aggr Count by Dimension Question

    Liam Do

      Hi All,

       

      How do I count the half_hr_bucket by date? I tried this expression but it does not return anything. Please help!

       

      =Aggr(count(half_hr_bucket),date)

        

      datehalf_hr_bucket
      1/2/201509:00 - 09:30
      1/2/201509:30 - 10:00
      1/2/201510:00 - 10:30
      1/2/201510:30 - 11:00
      1/2/201511:00 - 11:30
      1/5/201513:30 - 14:00
      1/5/201514:00 - 14:30
      1/5/201514:30 - 15:00
      1/5/201515:00 - 15:30
      1/5/201515:30 - 16:00
      1/5/201516:00 - 16:30
      1/5/201516:30 - 17:00
      1/5/201517:00 - 17:30
      1/5/201517:30 - 18:00
      1/6/201509:00 - 09:30
      1/6/201509:30 - 10:00
      1/6/201510:00 - 10:30
      1/6/201510:30 - 11:00
      1/6/201511:00 - 11:30
      1/6/201511:30 - 12:00
      1/7/201514:00 - 14:30
      1/7/201514:30 - 15:00
      1/7/201515:00 - 15:30
      1/7/201515:30 - 16:00
      1/7/201516:00 - 16:30
      1/7/201516:30 - 17:00
      1/7/201517:00 - 17:30
      1/7/201517:30 - 18:00

       

       

      Thank you for your inputs.