Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

How to customize a graph legend from the xml.

Received Response
1
Views
4
Comments
3193829
3193829 Rank 5 - Community Champion
edited Aug 13, 2024 7:05PM in Oracle Analytics Cloud and Server

Hi All,

I have lot of text displayed in the Legend. I am using the text in the graph measures, but the same looks clumpsy on the legend. I was wondering if we can edit the xml of the legend and remove the unwanted text. but i could see the following: column id of measure. how do we get the column ID, if i want to replace it with some other column ID.

<saw:columnRef columnID="c5676d94e3d86ae2b"/></saw:column></saw:measures>

or please let me know, if there is any other easier workaround for triming the Legend.

Thanks in Advance,

Kalpana

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    what about simply copying the column that you are using and changing the header either in the formula or the column properties window?

  • DanPryke
    DanPryke Rank 3 - Community Apprentice

    Create a second copy of the column and substring this second column to a smaller size but so that it still has some business meaning and use that in the legend instead

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Yep ... I mistook it ... the values are what you want to shorten ... good catch!

  • 3193829
    3193829 Rank 5 - Community Champion

    Hi Dan, Thomas,

    Thank you for your Reply.

    My requirement: I was displaying some text in the column heading and i wanted a line break for it. Coz, the same was displayed in the graph on hover. I got a simple solution for it.

    I have modified the Advanced tab xmlfor the graph and put the line break in the xml and it worked.

    just used "&#xA; " in the text where i wanted line break and it worked. It showed perfect in the Graph hover too.

    Thanks,

    Kalpana