Oracle Communities

Oracle Analytics and AI

Child Item

Order a Table by a Column not Included in a Table (DV Workbook)

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

State of Maine

Description (Required):

Currently if you use a Table Viz in a DV Workbook you are only able to Order By/Sort By a column that is included within the table, thus requiring that column to be also shown in the table. I would like the ability to sort a table by a column that is not displayed on the table.

Use Case and Business Need (Required):

I recently had to create a mobile version of another DV Workbook where I needed to have the results of the table returned in a specific order. As none of the columns we used in the 'Full' Workbook had a way to be sorted in the order needed, I had to create a Order By column in my database and bring it into OAC with by dataset. This worked, but now I have a random column that is shrunk down as far as it can go to not display any of the seemingly random (to a user) numbers used to order the table.

Enhancement Request / Service Request:

The request would be to either allow a table to be Ordered by a column that is not included in the actual results, kinda like a filter but only used to order the table. Or an alternative would be to allow us to hide columns in a table, so we could order by a column and then just not display it.

Find more posts tagged with

Under Review

Analysis and Data Visualization

Status: Under Review

Comments

user11336792

this enhancement is needed to do a silent order column in data visualizer

Bharath Raghupathi-Oracle

This is a very useful enhancement as we cannot hide the column as well in DV.

Michal Zima

You can sort visualization (which can be table) by column, which is not included in this visualization, but this columns must be a measure . But in plenty of cases, you would need ordering also by a column (not included in viz), which is an attribute. So this should be enabled as well.

Amrita Gupta-Oracle

If you are working with subject areas, then you can define a sort order column for any column, based on which the sorting will happen. However, when working with data sets, i do not believe we have any such solution. Therefore this would be a useful features, since we cannot hide columns in DV yet.

Marcelo Finkielsztein

Hello Everyone,

agree it is a nice-to-have feature. actually, i would like to see ALL the classic functionality implemented in DV.

Meanwhile (until oracle delivers a solution), suggestion: create a calculated column using a Rank() function on the sort-key. The rank will give you a 1,2,3,... series. then order the table by this ranking. assign a very small font size to this column.

Visually, users will see a "row number", and they may accept it more naturally.

(of course, you will beed to organize your sortkey to be desc)

hope this makes sense?

Marcelo Finkielsztein

Lucas Boyd

@Marcelo Finkielsztein I too would like to see all functionality Classic has, be moved into DV. I could have cut significant development time out if I could have just used JS, CSS, and HTML in a Text Box. I still don't know why they didn't keep that feature from Classic... The project I was working on had to move to DV as I needed to embed a Workbook into an external website while allowing the public to be able to access it. Which unfortunately Classic is not able to do. So it was a pretty frustrating experience trying to do in DV what I could easily due in Classic.

We did something similar to what you recommended, though instead of doing a Rank we created a new column in our Database and manually added the numbers. Not the ideal way, but we were trying to create a mobile friendly version of our Workbook so the rows had to be in a specific order that Rank wouldn't have given us. I do know that DV 'tries' to generate a mobile friendly version of a Workbook but when you have 20+ Tiles, 2 Gauges, and a Graph on a single Workbook; DV gets a bit confused!

Michal Zima

This Idea is duplicate to following:

https://community.oracle.com/products/oracleanalytics/discussion/20687/ability-to-set-sorting-on-alternative-column-in-dv-data-sets-based-on-attribute-column

which is in "Under Review" status.

Benjamin Arnulf-Oracle

https://community.oracle.com/products/oracleanalytics/discussion/comment/57615#Comment_57615

The current idea is from 2022. The idea Under Review is from 2024. I changed the status accordingly.

Bhaskar Konar

It'll be a great feature to have. Upvoted.