Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud November 2025 Update Unlock faster trends, personalized analytics, and efficient data management with the latest OAC AI and admin enhancements.
Introducing the Oracle Analytics & AI Challenge 2026 Showcase your Analytics & AI skills in this Community Challenge!

Oracle Analytics Cloud and Server

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

9

Views

1

Comments

User_J3N5J

User_J3N5J Rank 1 - Community Starter

Nov 17, 2022 1:21AM edited Aug 13, 2024 7:21PM in Oracle Analytics Cloud and Server

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

0

Answers

Gianni Ceresa Mod

Nov 17, 2022 8:47AM

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

0