Aggr Count by Dimension Question

[#1]

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.

[ramoncova06]

is this in a straight table ?

you can use

=count(total <date> half_hr_bucket)

[Qrishna]

see attached:

[#4]

@ Krishna: I used your expression and made small change and it worked for me now. Thank you!

@Ramon: Thank you for your reply.

[Qrishna]

Awesome. Please close the thread as 'Answered'