Sort Order — Oracle Analytics

Oracle Analytics Cloud and Server Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Cloud and Server Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Sort Order

Planned
11
Views
2
Comments
User_Q8Z9U
User_Q8Z9U Rank 1 - Community Starter
in Oracle Analytics Cloud and Server Idea Lab

Hello,

We noticed that the sort order in our faw visuals/ adw queries is in ASCII order. Per our business use case, it should be alphabetical order. See current sort format in our graph.

1- Legend_SortOrder_ASCII.png
2-Legend_SortOrder_ASCII-SORTBY_Option.png
Tagged:
4
Up
4 votes

Planned · Last Updated

Marked as planned based on using hidden columns to solve this use case.

Comments

  • Gabby Rubin-Oracle
    Gabby Rubin-Oracle Admin

    SQL and SQL-based tools are usually sorted based on ASCII order, where the uppercase letters come before the lowercase letters. The solution is usually to create a calculated field that uniforms the case and is used as a sort key. A feature coming shortly to workbooks will allow you to use a sort key in visualization while presenting only the 'display value' with the correct case (i.e. hidden columns).

  • Gabby Rubin-Oracle
    Gabby Rubin-Oracle Admin

    Hidden columns are currently planned for the January 2025 update.