Oracle Fusion Data Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion Data Intelligence

Categories

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

How to sum up all business unit data and show in as a another value in Bar chart

Received Response
63
Views
5
Comments
Ramesh Nayak
Ramesh Nayak Rank 2 - Community Beginner
edited Aug 13, 2024 7:52PM in Oracle Fusion Data Intelligence

Summary

How to sum up all business unit data and show in as a another value in Bar chart

Content

I have created a analysis report Active Head Count by Business unit and we have three business unit and bar chart has three business unit and I want to sum up three business data and show as Total value in bar chart and I want to know how we can do this in Fusion HCM analytics.

Thanks and Regards,

Ramesh

Tagged:

Answers

  • Nupur Joshi-Oracle
    Nupur Joshi-Oracle Mod

    Hi Ramesh ,

     

    My understanding of your requirement is - Headcount by Business Unit and overall headcount in a single DV project needs to be created.

    I have created a sample analysis covering following details :

    1. Headcount , Employee Headcount , Contingent Headcount & Terminated Headcount ( Different Tiles in a single Canvas ). So this shall help you see break up values 
    2. Bar chart showing break up Business unit wise.
    3. A filter on canvas on Business Unit. So you can utilize the same DV to review overall headcount as we as headcount by business units.

     

    Please import attached DVA in your FAW instance and verify.

    I hope this helps. Please do let me know if you have any queries on the same.

    Regards,

    Nupur

    Overall BU HC.png

  • Ramesh Nayak
    Ramesh Nayak Rank 2 - Community Beginner

    Thanks Nupur but in bar chart I am expecting one more bar and that should contain all business unit data.

    I have attached one screenshot as per screenshot yellow bar should sum of blue bar.

    Thanks and Regards,

    Ramesh

    BU.JPG

  • Nupur Joshi-Oracle
    Nupur Joshi-Oracle Mod

    Hi Ramesh ,

    In a single DV - In a single canvas this cannot be done. Having said that , in a single DV in two separate canvas I can think of an alternative for your requirement. I have attached sample image showing similar view.

    1. Select Bar Chart Viz

    2. Use headcount measure only as Y-Axis and don't use any other dim on the same canvas.

    Let me know if this helps.

    Regards,

    Nupur

    Overall BU HC V2.png

  • Ramesh Nayak
    Ramesh Nayak Rank 2 - Community Beginner

    Thanks Nupur but suppose I want sum up only two business unit data and show as one bar value in that case this will work?

    Thanks and Regards,

    Ramesh

  • Nupur Joshi-Oracle
    Nupur Joshi-Oracle Mod

    Hi Ramesh ,

     

    Yes , absolutely it will work as per filters used on DV.

     

    Regards,

    Nupur