2 Replies Latest reply on Jun 15, 2016 5:44 AM by Kristi Shepherd

    Interactive Variables

    Kristi Shepherd

      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.

          

      DateTeam ABackup Team Support
      Jun-16500
      Jul-161631
      Aug-16300
      Sep-16710
      Oct-16802
      Nov-16820
      Dec-16200
      Jan-171341
      Feb-17911
      Mar-17411
      Apr-17603
      May-17602
      Jun-171224
      Jul-171423
      Aug-17931
      Sep-171000