Oracle Analytics Cloud and Server

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

Change Horizontal Axis Labels

Received Response
11
Views
3
Comments
Rank 6 - Analytics Lead

Hi,

I have question about horizontal axis labes on bar graph.

I want to change ma horizontal labels to: name || name || name or name , name , name?

I know that I can change Format: Horizontal Axis Labels, however, there is no possibility to change the display format.

Default values are only separate space.

pastedImage_0.png

Any suggestions?

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 3 - Community Apprentice

    Hi,

    I can see that this is a bit of a strange requirement..

    Have a look at the XML and see if you can find a piece of code to edit the graph axis?

    Otherwise, as a workaround:

    You could change the column formulas of your horizontal columns to be:

    concat("Date"."Year",',')

    And the same for the rest of them (apart from the last column on the axis). They will then display on the horizontal axis as

    2016, 2016 / 01, 1/31/2016

    However this does change the actual values, so it's not just changing the horizontal axis. Something to think about.

  • Rank 8 - Analytics Strategist

    in the following example I had month (YYYY/MM) and revenue ... I added another column (Month || ' in ' || Quarter) ... then used that as my horizontal axis column ...  just make sure you create your custom column at the same grain as the x-axis column you really wanted to use (in your case looks like day or date)

    Capture.PNG

  • Rank 6 - Analytics Lead

    Thanks for reponse,

    I know this is a little strange problem, but don't know what people come up with.

    I'll try to implement your suggestions.

    BR

Welcome!

It looks like you're new here. Sign in or register to get started.