Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
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')
Awesome!! Thanks