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

Sankey Chart property

Accepted answer
132
Views
5
Comments
ym-Oracle
ym-Oracle Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server
image.png

In OAC Sankey Chart, Cost of Sales will align in the far right same as Operating Expense and Operating Profit.

How to Sankey Chart property so Cost of Sales align with Gross Profit.

Best Answer

  • Joel
    Joel Rank 8 - Analytics Strategist
    Answer ✓

    is this a screenshot from OAC? I don't believe it is as OAC automatically aligns the left and right of the sankey chart. I have attached a screenshot of a sankey chart with 3 categories similar to your screenshot and as you can see it lines up the left and right sides automatically.

    image.png

Answers

  • ym-Oracle
    ym-Oracle Rank 3 - Community Apprentice

    https://www.youtube.com/watch?v=u5R_7Ze0ZLA&t=1m58s

    If you notice COGS doesn't align with Gross Profit.

  • Joel
    Joel Rank 8 - Analytics Strategist

    This is because the data behind the sankey chart in the YouTube video seems to have a hierarchical structure where certain financial metrics roll up into higher-level metrics.

  • ym-Oracle
    ym-Oracle Rank 3 - Community Apprentice
    edited Oct 22, 2024 4:57PM

    We have similar financial hierarchical structure as the original image (similar to youtube link). I aware that data hierarchy is different. The 1st image clearly shows that hierarchy is different.

    We want Cost of Sales to align with Gross of Profit but couldn't find OAC sankey property for that.

  • Avinash Krishnaram-Oracle
    Avinash Krishnaram-Oracle Mod
    edited Oct 22, 2024 10:35PM

    Sankey has a Group By property that you can set to Value for hierarchical data.