Hello experts,
I want to build a Gantt chart for projects and their Tasks.
This is what I have so far:
Note that the "Ranking Dates" field is addressing the whole table. This causes some Tasks to be shown in the wrong place.
I want it to restart for every project. So the Tasks are sorted from oldest to newest.
It's really similar to the way it is right now, I just can't make it restart for every project...
The reference TWBX is attached.
Any help is really appreciated. Table calculations are still a big mystery for me... If someone know a good source of information on that, would be awesome.
Thanks in advance!
Rafael
Doh! I should have suspected a possible solution (and one I learned about from Jonathan), but at least writing about it here on the Forums allowed me to work through it on my own (although I am still curious why having the duplicate pill was causing an error)! I've found this to be the case many times and need to remember that when I am struggling with a problem...
If you convert the discrete DAY(Task Start Date) on the Rows shelf to ATTR(Task Start Date), this will remove the duplicated dimension which was causing problems with our Table Calc. I also converted the Task Start Date field to be a straight "Date" instead of "Date/Time" as the time values were being displayed as well originally.
With that setup, you can use similar Table Calc settings to what I mentioned above:
Let me know if you have any questions - my 8.2 TWBX is attached.
