I am sure this is not difficult but I am new to Tableau and trying to evaluate it as a project tracking tool for multiple projects. How can I create a gantt chart that tracks critical dates with various shapes and/or colors? It would be great to see todays date as a constant somehow as well.

Thanks but I was hoping for something more like the earlier pdf that would show a tick mark for each separate date within a location, not so much a continuous bar. Also, is there not a way to visually represent "today" on the chart?

Here's as far as you can get without reshaping your data. I strongly recommend you use the Reshaper tool and get all your dates in a single column. The tool with create an extra column for you with 'Start' 'Interim' & 'end' in it. Then everything becomes easier.

Also, the values for the dates from the database is showing '201204' i.e., year and quarter and I am unable to format it '2012 Q4'. I am currently making the date as string passing on to the dashboard so it is howing 201201 201301 and so on.

I saw you said to use the data reshape tool, but what do we do if that is just not workable. (33K+ lines in a database)

I dont know anyone that would record dates like Order Date, Picking Date, Shipping Date in one column, its not logical?

so how would you show a time line between the dates?

If i have an Order Number which then has these 3 dates and i want to see the difference from date 1 to 2 and then onto date 3 all in the same window, how is that done? As far as i can tell Tableau can only show a difference between 2 dates, past that its lost.

I saw you said to use the data reshape tool, but what do we do if that is just not workable. (33K+ lines in a database)

I dont know anyone that would record dates like Order Date, Picking Date, Shipping Date in one column, its not logical?

so how would you show a time line between the dates?

If i have an Order Number which then has these 3 dates and i want to see the difference from date 1 to 2 and then onto date 3 all in the same window, how is that done? As far as i can tell Tableau can only show a difference between 2 dates, past that its lost.

Cheers,

Ben

Hi Ben,

I'd recommend you start your own thread and attach a Tableau Packaged Workbook including some sample data so we can understand the structure of your data and better help you solve the problem. Feel free to tag me in the post by using the @Mention button in the bottom right and searching for 'Tom W'