Oracle Analytics Cloud and Server Idea Lab

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

Needs Votes
22
Views
1
Comments
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().

Tagged:
17
17 votes

Needs Votes · Last Updated

Comments

  • Rank 6 - Analytics Lead

    This sounds more like a bug than an enhancement, and should be addressed by Oracle accordingly.

Welcome!

It looks like you're new here. Sign in or register to get started.