Oracle Analytics and AI

Ramesh Nayak

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

Nupur Joshi-Oracle

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