Categories
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.
Comments
-
this enhancement is needed to do a silent order column in data visualizer
0 -
This is a very useful enhancement as we cannot hide the column as well in DV.
0 -
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.
1 -
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.
1 -
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
0 -
0
-
@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!
0 -
This Idea is duplicate to following:
which is in "Under Review" status.
1 -
The current idea is from 2022. The idea Under Review is from 2024. I changed the status accordingly.
0 -
It'll be a great feature to have. Upvoted.
0
