Need help in creating Waterfall Chart Using OTBI and to use it in Dashbaord

VaibhavChavan20 · Mar 25, 2025 8:34AM

Hi team,

I am creating a Dashboard, in the dashboard, one part includes creating a Waterfall Chart. I have pasted the waterfall chart below.

This is basically about the headcount. In the dashboard I have three paramters as Payroll Period, Payroll Name and Concept. and the three will be applicable to this chart, based on paramters values the headcount will reflect in the waterfall graph.

This chart will have previous months headcount, the new hires and transfer in current month, leavers in current month, and total headcount in current month.

I need your help in creating this headcount chart in OTBI. Also suggest me which subject area will be perfect for my case.
Please guide me on how should I acheive this?
If you came accross any similar dashboard or analysis, please share so I can refer it. This will really help.

Thanks in Advance.!
Regards,
Vaibhav

Bhaskar Konar · Mar 25, 2025 9:29AM

Need help in creating Waterfall Chart Using OTBI and to use it in Dashbaord

VaibhavChavan20

Mar 25, 2025

Hi team,
I am creating a Dashboard, in the dashboard, one part includes creating a Waterfall Chart. I have pasted the waterfall chart below.
https://us.v-cdn.net/6037859/uploads/C5AUXC4PHR6F/image.png
This is basically about the headcount. In the dashboard I have three paramters as Payroll Period, Payroll Name and Concept. and the three will be applicable to this chart, based on paramters values the headcount will reflect in the waterfall graph.

This chart will have previous months headcount, the new hires and transfer in current month, leavers in current month, and total headcount in current month.
I need your help in creating this headcount chart in OTBI. Also suggest me which subject area will be perfect for my case.
Please guide me on how should I acheive this?
If you came accross any similar dashboard or analysis, please share so I can refer it. This will really help.

Thanks in Advance.!
Regards,
Vaibhav

Hi @VaibhavChavan20,

Welcome to the Oracle Analytics Community.

Please take a look into the following OOTB report in the following location which might be a good starting point for your understanding and also it will help you to understand what subject area can be used, what SA is having what etc.