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 New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

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

2

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