I have a bar chart where I'm taking date in the format 'MMM YYYY' as dimension and sum of revenue as expression.
The problem I'm facing is, dates are like 1/12/2013, 15/12/2013 here it should club both 1st and 15th date and give single bar with Dec 2013. But instead it is giving 2 bars both having Dec 2013.
Make sure that you are not using the Date() function alone to get the dates in MMM YYYY format. Date() changes the format only, the underlying date is unchanged. That's why you are getting separate columns for the dates in Dec 2013.
To get the chart to work, use this logic in a calculated dimension* - assuming the date dimension field is called TrDate:
=Date(MonthStart(TrDate), 'MMM YYYY')
(Change TrDate to the correct name of the date dimension)
HTH
Jonathan
* you could also do this in the load script to create a DateMMMYYYY field that you could use as a dimension
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
