Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

sort months using calendar data source column

Hello,   I have found some posts referencing to this issue but could not find anything that could help me figuring out why it is not working.   I have this graph, below, which I want to show chro...
  • Anonymous's avatar
    Anonymous
    10 years ago

    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's avatar
Anonymous
Not applicable
10 years ago

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's avatar
Anonymous
Not applicable
10 years ago

That;s exactly it.

 

Thank you for your time and patience.

 

Kind regards,

Joaquim