Forum Discussion
sort months using calendar data source column
Anonymous My suggestion "explicitly" defines the columns and uses for them. The date hierarchy default "implicitly" handles the conversion. Your current INT column won't work sorting against a YearMonth because it is more granular. (you'll get an error).
You need to add both these columns to your calendar table.
YearMonth for display
YearMonthNumber for sorting the YearMonth display column.
Anonymous I see your point with the assumption that the defaulted hierarchy provided would sort all dates by your sort column, but obviously something is getting lost in translation. Which isn't suprising, given that you need sort columns in your date table depending on how you want to display things.
For example. To show the appropriate Monthname order you need an INT 1-12 MonthNumber, you can directly solve your issue by adding a YearMonth column and adding a sort INT column with YearMonthNumber (example: 201608 would be August of this year). This would give you the expected result, and also identify to the end user that you are looking at two different years.
Hi Anonymous
Thank you for the reply.
But do I not already have that column? the INT? using the correct format?
Just to clarify, in which table do I need to add the YearMonth column you mentioned?
And where do I add the sort INT column with YearMonthNumber that you also mentioned after that?
It is still a little confusing for me. My apologies.
Thank you.
JAnonymous My suggestion "explicitly" defines the columns and uses for them. The date hierarchy default "implicitly" handles the conversion. Your current INT column won't work sorting against a YearMonth because it is more granular. (you'll get an error).
You need to add both these columns to your calendar table.
YearMonth for display
YearMonthNumber for sorting the YearMonth display column.
That;s exactly it.
Thank you for your time and patience.
Kind regards,
Joaquim