1 Reply Latest reply on Aug 31, 2018 12:06 PM by Jim Dehner

    How to set up Parameter in this situation?

    Eason Chen

      I don't know how to disconnect with the SQL server so that you won't able to open my twbx file

       

      SO here is the screen shot. How can you set up the parameter for users to look at SPECIFIC month range?  Such as Jan to March.help.PNG

        • 1. Re: How to set up Parameter in this situation?
          Jim Dehner

          HI

           

          Parameters are a way for the user to input a single value into tableau - but that said they don't do anything by themselves - they have to be backed up with a calculation or a filter

          So if you would need to know 2 things - start and end date or start date and duration - that would be 2 parameters if the range (duration) is variable or only 1 if it is a constant number of months

           

          then you would write a formula like      Month(date) >=Month(start date) and month(date) <= month(end date)      it will result in a t/f filter that you can set to True

           

           

          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.