Oracle Analytics Cloud and Server

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

How to add two values ​​on a chart?

Accepted answer
43
Views
5
Comments
Vitalii_Alliance_dgtl
Vitalii_Alliance_dgtl Rank 3 - Community Apprentice

Hello everybody!
There is a problem, you need to show the amount of data and how much it will be in percentage on the graph. But I can't find one! I am attaching a screenshot of what it should look like. Maybe someone will have a solution. Thank you community)

Best Answer

  • Gianni Ceresa
    Answer ✓

    Go in Graph properties > Titles and Labels > Data Markers and select to always display the data label.

    But as said, it's one or the other, it can't display both the value and the percentage at the same time.

    The size of the bars already give a hint about the %, therefore if you display a small table with the % values next/near the chart, it will give all the info to the users.

Answers

  • Hi,

    What piece of product are you using?
    Is this a Publisher report? Is this a "classic" analysis? Is this a DV workbook? What product (OAS or OAC?) and version are you using?

    The category where you posted and the tags are contradictory…

  • Vitalii_Alliance_dgtl
    Vitalii_Alliance_dgtl Rank 3 - Community Apprentice
    edited July 2024

    Gianni Ceresa

    Product - OAS

    Version 12

  • Ok, it's a "classic" analysis, and let's take OAS as product (version 11 would be OBIEE, but that's a 10+ years old product). Moved your question to the right category…

  • Federico Venturin
    Federico Venturin Rank 7 - Analytics Coach

    Hi @Vitalii_Alliance_dgtl ,

    AFAIK displaying both the actual value and the relative percentage for a column is not possible. You have to implement a workaround, such as creating 2 different visualisations.