I have a data set similar to the sample workbook attached. Also, we are on version 9.2 so if it's a feature of 10 I won't be able to use it.
In this data I have sub Project ID's, and dates for scheduled action and drop dead. Some of the projects need to be scheduled and I can't exceed our weekly capacity (for this example 5 sub projects a week). Is there a way I can get the projects that are in the Pending Design and Pending Schedule columns assigned where they would fit in the Scheduled columns without going over capacity?
I have been trying solutions like an Axis2 calculation that contains an if sum(Count Projects) < 5 but nothing I am putting together is working. Any ideas from the community?
Did you find a solution for doing this? Here is an example reference of another user doing project management gantt charts in Tableau: Tableau 201: How to Make a Gantt Chart .
Let us know if you still have questions or issues and the response will bring this back to the top of the queue of questions.