Ability to Arbitrarily Order Visualization Data Columns

Andrew_L

Currently, visualizations (stacked Bars for this example) have limited options for ordering- alphabetical or reverse alphabetical only. However, oftentimes neither of these options meets business needs. For example, suppose we wanted columns to present in the following order

|PY MTD| |PY YTD| |CY MTD| |CY YTD| |Q3 Plan| |Q3 Actual|

This is not currently possible using the delivered sort function. Although we want "CY" to appear in the middle, this is not possible as it must be first or last in alphabetical order.

A solution that meets our need would like like one (or both) of the following

1. Drag and drop column to place it in the desired location for the visual

OR

2. Define a list order E.G. CY MTD =1, CY YTD =2, etc.

While we aware that there can be workarounds by using a different column for sort order, it is inflexible as an individual may want a different ordering for the same dataset depending on the reporting in question. As such the ability to decide where the columns go would be both a big time saver and more intuitive than having to prep the data to have a desired column order late.

Avinash Krishnaram-Oracle

Hi,

This enhancement is in our roadmap for the Sort feature. The feature is not prioritized for development yet. Unable to share any timeline at this point.

Thanks.

Gabby Rubin-Oracle

@Andrew_L the new ability to add a hidden column will allow you to define a custom sort key and use it to sort the categories based on your needs.