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

Reg: Month sorting in OBIEE graphs

Received Response
261
Views
3
Comments
User_JZKI6
User_JZKI6 Rank 4 - Community Specialist
edited Aug 13, 2024 5:15PM in Oracle Analytics Forum

Hi Team,

As we have graph in below format for diff years (like 2018 to 2020) it was showing like Alphabetical order, we have prompt to select the data, how to sort the graph by moth wise like(Jan, Feb ,Mar… Dec).

Any suggestions we are using version Oracle Business Intelligence 12.2.1.4.0.

 Regards,

Tagged:

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    In the RPD you should set the sort order column for your text month logical column. Pick a column which can be sorted correctly for months (like the month number or something like that) and use that one as sort column for the text versions of months.

  • User_JZKI6
    User_JZKI6 Rank 4 - Community Specialist

    Hi Gianni,

    Thanks for your reply.

    In RPD we don’t have any columns to sort the MMYYYY field, so we can create new column by using case statement and set the numbers for the month year and use that column as sort order column.

    Regards,

  • User_JZKI6
    User_JZKI6 Rank 4 - Community Specialist

    Hi Gianni,

    Thanks it worked.

    Regards,