Month/Year repeating and Sort

[cbaqir]

I know I have run into this before and suspect I need to do something like add another dimension in my AGGR statement but I can't figure out what is happening...

I want the months in the Readmits per Month line chart to show Jul 2013, Aug 2013, Sept 2013 etc but Jul 2013 shows up multiple times etc with the dimension of =date(ADMIT_DATE, 'YYYY-MMM')

Any ideas?

[sunny_talwar · Accepted solution]

Try this

=Date(MonthStart(ADMIT_DATE), 'YYYY-MMM')

[cbaqir]

There are no data points in the line graph?

[sunny_talwar]

I saw that too... can you create a field in the script instead of using a calculated dimension and use that in your aggr() expression?