12 Replies Latest reply on Nov 15, 2014 8:34 PM by Brian Calvanese

# How does one use Multiple measures in the same bar graph across one specific time period as a Waterfall Chart ?

Hi,

I need to create a Waterfall chart across a few measures for a specific dimension and a specific time Period.

I have tried

1) Creating a running sum total

2) Adding the (-ve)Sum as the Size of the measure.

3) Converting to Gantt chart.

All these work fine for a Single measure across values of a dimension. But I am not able to find a solution where one can plot different Measures across a specific Dimension value as a filter.

The changing of table calculation to running sum, and then trying the difference from option across a row above gives me an error.

Is this scenario catered for in tableau? ( Multiple measure waterfall chart Measure1,Measure2,Measure3 across a specific dimension) .

I have also seen a related post but it doesn';t give me the requisite solution (http://community.tableau.com/thread/118760)

Bala

• ###### 1. Re: How does one use Multiple measures in the same bar graph across one specific time period as a Waterfall Chart ?

Hi Bala,

Attached workbook with multiple measures (sales and profit) shown in a waterfall chart by sub category.

Vertical Allignment  -  on on top of another

Horizontal Allignment - next to each other

Dual Axis - Two measures showing on same waterfall

Not sure if this is what you were looking for - but without example data or mock up of what you want to achieve I struggled to think how else multiple measures in a waterfall would make sense in the type of applications that I am used to.

Best regards

Ian

1 of 1 people found this helpful
• ###### 2. Re: How does one use Multiple measures in the same bar graph across one specific time period as a Waterfall Chart ?

Hi Ian,

Thanks a lot for the quick response.

The workbook which you had sent was very helpful. But was not the solution I was looking out for.

I wanted to implement a waterfall chart across Measures

Eg. 1,2,3,4,5,6 and 7 Being the measures across

Dimension TimeID : 1

Product ID : "ProductA "

And all these different measures calculated for the above mentioned dimensions.

I'm attaching a picture of what I want it to look like.

Thanks,

Bala

• ###### 3. Re: How does one use Multiple measures in the same bar graph across one specific time period as a Waterfall Chart ?

Hi Bala

I'm struggling to think of an example in which you would want to add/subtract "different" measures together and come up with a Grand Total - can you expand in your example of what the measures 1-6 could be?  Have you got some representative example data to help putting together an example?

Best regards

Ian

• ###### 4. Re: How does one use Multiple measures in the same bar graph across one specific time period as a Waterfall Chart ?

Hi Ian,

Thanks for the continual help.

For example the Measure 1 , Measure 2 and so on are the contributions to the total cost of raw materials purchased because of the factors like market, market share and similar such factors which are not dimensions and those which couldn't be converted to dimensions.

The workaround that I have followed is to bring in individual bars and then put them all together in one worksheet which has the same axis range (By creation of invisible reference lines at the maximum and minimum of the measures and adding these fields to the level of detail pane).

Thanks,

Bala

• ###### 5. Re: How does one use Multiple measures in the same bar graph across one specific time period as a Waterfall Chart ?

It sounds like reshaping your data may be the best option - having all those measures in one column.

• ###### 6. Re: How does one use Multiple measures in the same bar graph across one specific time period as a Waterfall Chart ?

Hi Balakrishnan,

I am having the same problem as you, needing to create a Waterfall chart using different measures which are each contributions to a total. I was wondering if you ever managed to find a solution?

Many thanks,

Max

• ###### 7. Re: How does one use Multiple measures in the same bar graph across one specific time period as a Waterfall Chart ?

Hello I am trying to build a waterfall with several dimensions where each dimension represents a portion of a total Price (The Final column would be Price-(SUM of Dimensions). All Dimensions should be represented as the differential from the Total Price and descent or raise according to their values until the last one aligns with the Final Price column.

No running totals is available and also reshaping is not quite an answer due to the volume of data.

Any suggestions?

• ###### 8. Re: How does one use Multiple measures in the same bar graph across one specific time period as a Waterfall Chart ?

Can you create a new thread with an attached packaged workbook? so your question will get more attention and answers.

thanks

• ###### 9. Re: How does one use Multiple measures in the same bar graph across one specific time period as a Waterfall Chart ?

The Community webpage is not loading properly, I am running the latest

Firefox version

I cannot see anything, unless I hit reload and it only shows the page that

What can I do?

Regards,

Edmundo Munguia Oliver

Technology Innovation - Mexico

Office: +(52) 81.8888.4251 CEMEX Net: 80523.4251

mailto: edmundo.munguia@cemex.com

www.cemex.com

• ###### 10. Re: How does one use Multiple measures in the same bar graph across one specific time period as a Waterfall Chart ?

thanks

• ###### 11. Re: How does one use Multiple measures in the same bar graph across one specific time period as a Waterfall Chart ?

completely and this prevents me to see the rest of the elements (this

happens behind my firewall - and asking IT to change things is close to

impossible, and this happens with all browsers: IE 10, Chrome 30, FF 24

I have submitted the issue and a png with what I am trying to achieve-

Regards,

Edmundo Munguia Oliver

Technology Innovation - Mexico

Office: +(52) 81.8888.4251 CEMEX Net: 80523.4251

mailto: edmundo.munguia@cemex.com

www.cemex.com

• ###### 12. Re: How does one use Multiple measures in the same bar graph across one specific time period as a Waterfall Chart ?

Here's an example that doesn't require reshaping data...

If you have 8-10 columns, you can piece together multiple sheets to create a multi-measure waterfall.

1) you have to be careful how you calc the 'blank base'... if the measure breaks across the zero line, you have to separate the calc above and below zero.

2)  create a calc'd field that takes the max of each sheet's value and another for the min of each sheet's value (in case of negatives).  Use these fields as blank reference lines to set the scale for each chart.

3)  floating the pieces together onto a dashboard allows you to use the x, y, w, h coords to line everything up with precision.

An example is attached... note, I didn't take the time to complete all of the logical calc's... just did enough to illustrate the point.