How to sort by a column not used in a graph — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to sort by a column not used in a graph

Received Response
81
Views
4
Comments
3294318
3294318 Rank 3 - Community Apprentice

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.

pastedImage_0.png

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.

  • 3294318
    3294318 Rank 3 - Community Apprentice

    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.

  • 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).

  • 3294318
    3294318 Rank 3 - Community Apprentice

    That's exactly what I was looking for. Thank you for the information!