Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to sort by a column not used in a graph

I am currently working on a turnover graph that displays the projected turnover and YTD turnover rates in a lines and the total terminations per month in bars. The "Month Only + Year" field I have brought it displays Jan-16, Feb-16 and so forth but when I sort them it shows them alphabetically. I have another field called Month but it displays the date and time and I do not want to display that information so I am trying to use the "Month Only + Year" field. When I add the Month field to the graph, it sorts the graph correctly but adds a line for Month since that is where it seems to work the best for the graph but I do not want to display this line.
So is there a way you can hide a line or is there a way to sort a graph by a column that is not used in the graph?
Below is the graph I have currently but DO NOT want the read line to display.
Answers
-
Hi,
Ideally you set the "sort order column" attribute in the RPD for the "Month Only + Year" logical column (in the business model) as it allows your to sort textual months in the right way. But sometime this sorting doesn't work well (I saw that mainly in pivot).
If you don't want/can't do that (or it doesn't fix your issue) you put the "month" (the one giving the right sort on the X axis with your "Month Only + Year" and you make that column as hidden. If you put it above the "month only + year" it will force the right sorting but because it's hidden only the "Month Only + Year" is on screen.
0 -
Thanks for the response and I will check in the RPD if it doesn't work to hide the month. In OBIEE, where can you hide a column for a graph? I haven't been able to find that in any of the properties.
0 -
Sadly the UI is a bit inconsistent ....
For a chart you must hide the column in the "Criteria" tab (so it will be hidden for all the views), "Column properties" > "Column Format" > "Hide" (a checkbox on the top-right).
0 -
That's exactly what I was looking for. Thank you for the information!
0