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.
