<< Back

Thicken your Gantts

I was recently handed over the following chart to continue working on. It is a dual axis with both marks cards as Gantt bars. One axis has the thick horizontal bars and the other has the vertical end points for actual v budget as well as prior month (see below). What I want to do to improve this slightly is thicken the vertical endpoints so they are more distinguishable (if I increase the size on the marks card it only increases their height, I want to increase the width).

 

 

Initially I tried putting a calculation of SUM(0.3) on size but this is what happened.

 

We can see here that the thickness of the Gantt endpoints are dependent on their distance from zero – this wasn’t what I was going for as I wanted them to be of equal size.

This comes down to Tableau’s Order of Operations. As the calculation ‘SUM(0.3)’ is seen around the same level of detail as a Measure filter I needed to give this calculation a boost. The way I did this was by making it an LOD. It didn’t take much, just changing the calculation from ‘SUM(0.3)’ to ‘{SUM(0.3)}’ gave me this.

 

 

These were a little too thick for me so I brought down the 0.3 to 0.1 and that gave me the look I was after.

 

 

Now my Gantt endpoints were distinguishable from each other and most certainly visible.

 

If you would like to construct some Gantts where they do vary in size I would suggest reading Gwylim Lockwoods blog here.

 

 

Joe Macari

London, UK

One thought on “Thicken your Gantts

Leave a Reply

Your email address will not be published. Required fields are marked *