Trying to sort the month prompt on a dashboard — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Trying to sort the month prompt on a dashboard

edited Sep 26, 2020 12:48PM in Reporting and Analytics for HCM 2 comments

Summary

The prompt for Month using a Case to convert to month names instead of integer is now sorting alphabetically by month instead of by integer

Content

Hi 

I have looked through a number of posts on the forum but can't find anything that can help with changing a prompt to sort a month name (e.g. January etc) by calendar month and not alphabetically.

I've done a case statement to show to convert Time, Month to INT (e.g. 01, 02), and where it is 01 then 'January', 02 = 'February' etc.  However, the prompt in the dashboard is now showing April, August etc., in alpha rather than calendar order.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!