10 Replies Latest reply on Jun 28, 2017 7:43 AM by Mark Fraser

    Waterfall Chart Issues

    Colin O'Brien

      Hi All!

       

      I'm looking to recreate this chart as closely as possible... the x axis is full of dimensions which aren't showing on this particular chart

      Capture.PNG

      I've run across a number of problems with recreating this in Tableau:

      • The y axis has to be by 'Number of Records' as the bars have to be 'running sum of total' to create a waterfall chart in Tableau. Even though I can label by %. This isn't a huge problem as number of records isn't the worst metric to have showing
      • I can't present the subtotal bars in the middle (which total all the bars preceding) as subtotaling will only total by the colour type. e.g. Blue Total shows as 13.5 %. This is because you can only subtotal by Pane, Cell etc. and can't do running sub total as far as I know.
      • The Grand Total bar at the end refuses to be coloured in segments like the others. To solve this I've simply created another view but if I'm missing something and this can be achieved, please let me know!

       

      Essentially, what I really need is the subtotal bars in the middle and I've found no way of recreating these in Tableau. I've tried adding reference lines which would just about do but I haven't figured out to make it like so:

      Untitled.png

       

      Adding a colour below a reference line will wipe out all the other colours below it. I think this is most do-able and will be looking into it again. Possibly adding a label on the reference line to show the sub-totals that I want.

       

      If anyone has figured out something remotely close to this I'd be eternally grateful! I've poured a lot of time into this for very little return

       

      Here's what I have so far

       

      Capture.PNG

      Attached is a quick mock up of what I'm working with

       

      Regards,

      Colin