Categories
- All Categories
- 5 Oracle Analytics Sharing Center
- 11 Oracle Analytics Lounge
- 190 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.4K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 65 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
DV: Logical Date columns sort differently on a chart vs a table

Jayko Paten
Rank 4 - Community Specialist
Sorting on a logical date column should be consistent across visualization types.
Currently a logical column (e.g. CAST ('01-' || MMM-YYYY) AS DATE)) sorting within a table does correctly use the implicit sort order defined in the RPD, a chart type does not sort using the same implicit sort order.
Per O Support:
The SortKey function should only be used on simple column references. The SortKey function should not be used on more complex expressions like CASE WHEN or CAST().
17
Comments
-
This sounds more like a bug than an enhancement, and should be addressed by Oracle accordingly.
1