Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Sort graph by month

Received Response
271
Views
2
Comments
TKQ5Q
TKQ5Q Rank 3 - Community Apprentice
edited Aug 13, 2024 5:12PM in Oracle Analytics Forum

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:

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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.

  • Gianni Ceresa
    Gianni Ceresa Mod

    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).