Dimension not grouping, tried Aggr also not working.

[mrichman]

Hi All, 

I have a date dimension calculating total x values, however my chart does not group them (i'm using a sum). I tried the aggr function but it is not working. 

Do you probably know whats going on?  Thanks in advance! 

Thanks in advance

[lironbaram · Accepted solution]

hi 

if you have a date field and you only change the format , it will still display a column for each date 

if you want it to disaply a month aggregation 

in the dimension use this 

=date(monthstart(DateField),'MM/YYYY')

[mrichman]

Awesome!! Thanks