Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
date | half_hr_bucket |
1/2/2015 | 09:00 - 09:30 |
1/2/2015 | 09:30 - 10:00 |
1/2/2015 | 10:00 - 10:30 |
1/2/2015 | 10:30 - 11:00 |
1/2/2015 | 11:00 - 11:30 |
1/5/2015 | 13:30 - 14:00 |
1/5/2015 | 14:00 - 14:30 |
1/5/2015 | 14:30 - 15:00 |
1/5/2015 | 15:00 - 15:30 |
1/5/2015 | 15:30 - 16:00 |
1/5/2015 | 16:00 - 16:30 |
1/5/2015 | 16:30 - 17:00 |
1/5/2015 | 17:00 - 17:30 |
1/5/2015 | 17:30 - 18:00 |
1/6/2015 | 09:00 - 09:30 |
1/6/2015 | 09:30 - 10:00 |
1/6/2015 | 10:00 - 10:30 |
1/6/2015 | 10:30 - 11:00 |
1/6/2015 | 11:00 - 11:30 |
1/6/2015 | 11:30 - 12:00 |
1/7/2015 | 14:00 - 14:30 |
1/7/2015 | 14:30 - 15:00 |
1/7/2015 | 15:00 - 15:30 |
1/7/2015 | 15:30 - 16:00 |
1/7/2015 | 16:00 - 16:30 |
1/7/2015 | 16:30 - 17:00 |
1/7/2015 | 17:00 - 17:30 |
1/7/2015 | 17:30 - 18:00 |
Thank you for your inputs.
is this in a straight table ?
you can use
=count(total <date> half_hr_bucket)
see attached:
@ Krishna: I used your expression and made small change and it worked for me now. Thank you!
@Ramon: Thank you for your reply.
Awesome. Please close the thread as 'Answered'