3 Replies Latest reply on Sep 14, 2018 12:59 PM by Naveen B

Displaying period of time between two dates -- rounding the ends of a gantt bar

I am trying to build a Tableau resume and I wanted to show my timeline of work history, but I am having a couple of issues that I need some help with.

For each position I have worked, I have the start date of the job, the end date of the job, and the title.  I thought I should be able to make a Gantt Bar chart which would show each job on a row and the start date and length of time (basically the bar would represent the time between the start date and end date).  I have calculated the difference between the start date and end date using DATEDIFF.  But, I'm having trouble visualizing the Gantt Bar chart.  I have the start date on columns (MONTH(Start Date)) as a continuous variable and the marks card is set to Gantt but when I set my calculated Months from start field on the size it is not sized appropriately.  I would expect that the bar would reach from the start date to where the end date would be, but that is not what is happening.

Any help would much appreciated as I thought I knew what this was doing, but I guess not and I cannot find anything out there with the same scenario I'm trying to do.

Secondly, once I get the bars figured out I am trying to round the ends of the bars.  I know how to do this using a dual axis chart for one end of a bar, but is there a way to do this for both ends of the bar?

Kyle

• 1. Re: Displaying period of time between two dates -- rounding the ends of a gantt bar

Hi Kyle ,

It seems you are expecting like below attached the workbook for the same

BR,

NB

• 2. Re: Displaying period of time between two dates -- rounding the ends of a gantt bar

Naveen,

yes, so it looks like I needed to make my DATEDIFF calculation on 'days' not 'month' which is what I had.

Do you have any suggestion on my second part of the question?  Making rounded ends for the bars?

• 3. Re: Displaying period of time between two dates -- rounding the ends of a gantt bar

yes, so it looks like I needed to make my DATEDIFF calculation on 'days' not 'month' which is what I had.

I thought it would be easy to understand and show in simple way thats why used exact date and Day in Date diff

Coming to rounded end bars check the link below

Hope this helps