Pivot Chart Properties — Oracle Analytics

Oracle Analytics Cloud and Server

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

Pivot Chart Properties

Received Response
11
Views
6
Comments
3512682
3512682 Rank 3 - Community Apprentice

Hi Folks,

A simple report was created using PIVOT table and default Bar Chart.

The report looks good but the bar chart needs some custom change for display.

In chart, x- axis 3 column names are clubbing for each bar. where as I have to display only one name say region name under each bar and not display other 2 column names.

Any properties change or any custom change needed?

I hope you understood the scenario.

Thanks

Answers

  • asim cholas
    asim cholas Rank 6 - Analytics Lead

    Cant you remove the column names in criteria itself? show us some images to understand the clear issue.

  • 3512682
    3512682 Rank 3 - Community Apprentice

    I need the those columns in the pivot table view but want only one to be displayed under each bar in bar chart.

    So can we format the display in such a way that only one column name be displayed?

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    OBIEE is an on-screen analytics tool ... from an information stand point the axis labels having all three elements is valid, valuable and by design.

  • asim cholas
    asim cholas Rank 6 - Analytics Lead

    pastedImage_0.png

  • 3512682
    3512682 Rank 3 - Community Apprentice

    Asim, Duplicate the columns and remove their names?

    Explain?

  • asim cholas
    asim cholas Rank 6 - Analytics Lead

    why not change the name in Titles and labels?