Forum Stats

  • 3,815,470 Users
  • 2,259,032 Discussions
  • 7,893,112 Comments

Discussions

Sort graph by month

TKQ5Q
TKQ5Q Member Posts: 22 Green Ribbon

Hi Sir,

I tried creating the graph below using the month column created from the Calendar/Date function.

Is there a way to sort the month, Jan, Feb, Mar etc in Enterprise Edition 11.1.1.7 analysis?

Thank you for your help.

Tagged:

Best Answer

  • Gianni Ceresa
    Gianni Ceresa Managing Director | Oracle ACE Director Member Posts: 6,536 Blue Diamond
    Answer ✓

    Or model your data correctly by setting the sort order column for your "month name" column in the RPD.

    By the way, you have a bunch of open thread without any feedback, you should consider taking 5 minutes to go back there and check if you got what you looked for and close threads if needed (because remember this is a community forum: you take and you give, you closing threads is part of giving).

Answers

  • Christian Berg-0racle
    Christian Berg-0racle Everything Analytics And Data Member Posts: 9,616 Gold Crown

    Sorting is alphanumeric. You have to either sort on another column which represents the month as a number 1 - 12 or prepend the number to the name "01 - January" or the likes.

    TKQ5Q
  • Gianni Ceresa
    Gianni Ceresa Managing Director | Oracle ACE Director Member Posts: 6,536 Blue Diamond
    Answer ✓

    Or model your data correctly by setting the sort order column for your "month name" column in the RPD.

    By the way, you have a bunch of open thread without any feedback, you should consider taking 5 minutes to go back there and check if you got what you looked for and close threads if needed (because remember this is a community forum: you take and you give, you closing threads is part of giving).