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

How we can ORDER BY Month names in calender format

Received Response
1
Views
1
Comments
User_J3N5J
User_J3N5J Rank 1 - Community Starter
edited Aug 13, 2024 7:21PM in Oracle Analytics Forum

I have a field of Period name with values like Aug-22, Sep-22, June-22, May-22,...

How i can able to order by this period name in a Calender manner May-22, June-22,Aug-22, Sep-22,..

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Set a sort order column on that logical column pointing to a column having a format that can be sorted, something like YYYY-MM.