I am not sure if this is possible but if anyone knows how to do it or can help in any way it would be much appreciated. I have a situation where I have an Excel spreadsheet that I want to put into Tableau and once it is in Tableau then the goal is for it to be fully automated and interactive without changes necessary to be made in Excel. I have multiple calculated variables but there are 3 variables of interest that this question particularly pertains to (Team A, Backup team, and Support Team) seen in the example below. I would like these variables to have the capability to be adjusted and interacted with in Tableau. There are calculated variables based off of these related to project time lines, budget and inventory. So just looking at one of these variables to start with, for example in June 2016 I plan to have 5 people from Team A work on this project but I'd like to see if I changed that value to say 7 then how would the inventory for June and the carryover inventory change in the later months (holding all else constant or changing later month's Team A values to different scenarios as well). All of the numbers listed are the expected values of people needed from that team but I would like to be able to change any of these numbers for exploration purposes and see the resulting impact on the calculated fields. I would need to make it so that these numbers can be adjusted in Tableau for individual months. I thought about creating parameters but if I create one parameter for Team A then it will change that value to one value for all of the months, which we don't want. Then if I create a parameter for each of these variables for each month I could get the interaction I require but the dashboard would be overwhelmed with parameter controls (36 for 1 year). Thanks for any help.
|Date||Team A||Backup Team||Support|