3 Replies Latest reply on Oct 19, 2012 10:04 AM by Robin Kennedy

    Gantt over time with summed bar

    Andrew Jones

      I'm having trouble creating the following chart in Tableau.

       

      I have data that looks like this:

       

      namedatecount
      a11/10/20122
      a12/10/20123
      a13/10/20122
      b12/10/20126
      b13/10/20122
      b14/10/20123
      c14/10/20122
      c15/10/20122

       

      And I want to create a bar chart that has the sum of the count on the y axis and time on the x axis. The width of the bar should be the length of the time, like a Gantt chart. Each name has its own bar. Here is an image that shows what I am after.

       

      tableau-bar-gantt-example.png

       

      The bars should overlap if the times overlap.

       

      I have tried various things in Tableau but haven't really got close.

       

      Is this kind of chart possible in Tableau? If not in 7, will it be in 8? I have heard it makes it possible to create some more complex chart types.

       

      A workbook is attached with the data.

       

      Thanks for your help,

      Andrew