Oracle Analytics Cloud and Server

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

Repeated labels on chart axis

Received Response
51
Views
2
Comments

Summary

Repeated labels on chart axis

Content

Does anybody know why this might be happening?

--     simple XLS as a Data Source - One description Column and a number Column (Number summed, values eith 1,2 or 3)

--     When I create a barchart of any type it shows two entries per number

so my X Axis on a horizontal bar is showing 1,1,2,2,3,3 when it should be showing 1, 2, 3

Same affect if flipped to Y axis...

Is this a bug?

I've tried:

--     Changing it to plane CSV after moving through a Data Flow

--     Changing it to two different CSV's (Dim & Fact and toggled SUM on the number)

Still no joy..... I'm missing something here....

Answers

  • FTisiot
    FTisiot Rank 6 - Analytics Lead

    hi Ciaran,

    Are you sure there are no trailing spaces in your description column e.g. "1" and "1 " are treated differently

  • Stephan Reyher-Oracle
    Stephan Reyher-Oracle Rank 3 - Community Apprentice

    Hello,

    you need to modify the formatting of the value axis. By default this is set to "no decimals". In your case, you need to set to at least one decimal (0.1).

    Value Axis.PNG

    This will solve your issue.