nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Sort Order

User_Q8Z9U

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

Find more posts tagged with

Planned

FDI

ADW

Status: Planned

Comments

Gabby Rubin-Oracle

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

Hidden columns are currently planned for the January 2025 update.