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

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

Ramesh Nayak

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

Nupur Joshi-Oracle

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

Ramesh Nayak

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

Hi Ramesh ,

 

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

 

Regards,

Nupur