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

VaibhavChavan20

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

https://community.oracle.com/products/oracleanalytics/discussion/25065/need-help-in-creating-waterfall-chart-using-otbi-and-to-use-it-in-dashbaord

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.

This is will return results like following but it is achieved using stack bar instead of waterfall.

Hope this help.

Thank you.

VaibhavChavan20_

Thank You @Bhaskar Konar
This will really Help..

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/66031#Comment_66031

Hi @VaibhavChavan20_ ,

Glad to hear that.

Please select the answer if it help you as it'll be helpful for fellow community members in future.

Thank you.