Anybody know about Waterfall charts?

[acabugason]

Has anybody heard of and know how to create waterfall charts in Report Studio? It is similar to the progressive chart. The difference is that the waterfall chart has two measures while the progressive chart only has one.

Any insight is greatly appreciated.

[trevorp]

Hi

I had the same problem recently where my client required a waterfall graph. I ended up using a stacked barchart and made one of the measures transparent (see attachment)

              Measure 1   Measure 2 (cumulative)
Data Item 1    10       0
Data Item 2   20     10 (measure 1)
Data Item 3   25     30 (measure 1 + 2)
etc      
   
Put this into a stacked barchart and make the measure 2 transparent in the graph and make sure it is the bottom measure. You would also need to include a sort order in the query report providing data to the graph

[almeids]

Haven't done anything with waterfall charts but I think one is included in the Great Outdoors samples.

[acabugason]

trevorp ... this is very helpful! I'll give it a shot.

almeids ... I'll check out the samples.

thanks to both!

[AM]

Hi

I had the same problem recently where my client required a waterfall graph. I ended up using a stacked barchart and made one of the measures transparent (see attachment)

Thanks trevorp, a very elegant solution.
AM.