I've created a bar chart which counts orders and is dimensioned by Month & Year.
If I set the dimension to just year, or just month, the sorting on the chart is fine:
However, if I add in the year, then it all goes potty:
I'm creating this date in the load script from a column in oracle:
MakeDate(left("CREATION_DATE",4),mid("CREATION_DATE",5,2), right("CREATION_DATE",2)) as FormattedCreationDate,
..and using this as the dimension:
Month([FormattedCreationDate]) & '/' & Year([FormattedCreationDate])
Any ideas what I need to do in order to sort the dates correctly?
Solved! Go to Solution.
You can avoid all of these problems if you treat the dates differently in the script.