Skip to main content
R
RyanDiehl
Newcomer
April 29, 2022
Solved

Waterfall Chart in BI Viewer?

  • April 29, 2022
  • 3 replies
  • 0 views

Has anyone been able to build a waterfall chart in BIViewer? I feel like this is something that I should be able to be done, but I can't find anything on it. Anyone know if this can be done? I know there is an advanced chart for waterfalls. 

Thanks

Best answer by Sai_Maganti

v6.6 Waterfall chart added as a stand alone component
v6.8 Waterfall chart added to OneStream windows excel

but no Waterfall chart in BIViewer component out-of-the-box yet

3 replies

S
Sai_MagantiAnswer
Newcomer
April 30, 2022

v6.6 Waterfall chart added as a stand alone component
v6.8 Waterfall chart added to OneStream windows excel

but no Waterfall chart in BIViewer component out-of-the-box yet

    M
    MarkHoughton
    Contributor
    September 13, 2023

    Hi,

    Is this the sort of chart you require ? This uses the Basic chart set to Waterfall

    MarkHoughton_0-1694613469149.png

     

    R
    RobSnelson1
    Newcomer
    February 8, 2025

    I was able to build something very close to a Waterfall chart using Range Charts. It requires a few additional steps to generate the data required. I set up Accounts for each of the incremental accounts in the chart and then used UD8 to set up a member for startPos and endPos. I have a CubeView set up with the Accounts  in rows and UD8 in columns. Then you can either write a Member Formula that calculates the ranges required for each of the columns, or a some other BR to generate the chart from source accounts...so for instance if you have 5 steps: Revenue = 100, COGS = -65, Opex = -25, OtherInc = +15, Taxes = -5 and finally NetIncome would then be = 20. The steps in the Table would be Revenue startPos = 0 and endPos = 100, COGS startPos = 35 and endPos = 100, Opex startPos = 10 and endPos = 35, OtherInc startPos = 10 endPos = 25, Taxes startPos = 20 andPos = 25, and then NetIncome startPos = 0 endPos = 20.

    Terms & ConditionsAccessibility statement