7 Replies Latest reply on Nov 18, 2019 5:35 AM by Jim Dehner

    Inputting row-based parameters (like a form)

    Hassan Kassem

      Hello everyone,

       

      So I'm basically trying to have percentage allocation, that need to be inputted by user, between suppliers to be used in other calculations.

       

      Below is an example:

       

      I need to be able to change these percentages just like excel:

       

      How do I allocate different percentage for each supplier in Tableau?

       

      I just scratched on the labels for confidentiality of the data.

       

      Thank you so much in advance!

       

      Hassan Kassem

        • 1. Re: Inputting row-based parameters (like a form)
          Jim Dehner

          Good morning

          Parameters are single valued user input that are global and remain static until changed by the user

          are you trying to have the user input different values for each supplier?  

          Tableau does not support that with a single parameter - you would either need multiple parameters or create a separate file with the factor for each supplier and join it with your original data file

           

          Sorry

          Jim

          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

          • 2. Re: Inputting row-based parameters (like a form)
            Hassan Kassem

            Yes I am having the user inputting different values for each supplier (might even need to disregard some suppliers).

             

            It would be ideal if the user can choose the suppliers and allocate a different value for each of them.

             

            Hassan

            • 3. Re: Inputting row-based parameters (like a form)
              Jim Dehner

              This is not a good application for parameters - I would use a separate excel file with the supplier name and factor - load that into tableau and join on supplier name

               

              Jim

              If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

              • 4. Re: Inputting row-based parameters (like a form)
                kaviyarasu.jayavel

                We have same sort of requirement, business would like to enter sample value for each country and use for further calculation. They may choose 5 country or 10 country and key-in  5 / 10 sample value for each country.

                Any other suggestion would be helpful.

                • 5. Re: Inputting row-based parameters (like a form)
                  Jim Dehner

                  If I understand the issue I would use sets and set actions to do this

                   

                  I keep a solution using value pickers and set action on my public site at  Tableau Public

                  It provides capability to select values from 3 different dimensions and the change the value of the related sets

                   

                  it returns this - it model includes step by step how to instructions - feel free to download it and use it as a model - that is why it is there

                   

                  Jim

                  If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

                  • 6. Re: Inputting row-based parameters (like a form)
                    Hassan Kassem

                    Hello,

                     

                    I have figured out on how to solve the issue myself.

                     

                    Let's assume that we have a column called Country that has 3 values: United States, United Kingdom, Iraq

                     

                    1- You would create 3 parameters; one for each name them US, UK, IQ for example

                    2- Give the parameters values/range or whatever is relevant

                    3- Create a calculated field with the following:

                    if ATTR([Country])='United States' then [US]

                    elseif ATTR([Country])='United Kingdom' then [UK]

                    elseif ATTR([Country])='Iraq' then [IQ] END

                    4- Voila! you can use this field for further calculations

                     

                    Atleast this worked for me.

                    • 7. Re: Inputting row-based parameters (like a form)
                      Jim Dehner

                      Glad you found a solution

                      Jim