5 Replies Latest reply on Feb 24, 2017 5:06 AM by Mark Fraser

    Formula

    suvas.chandra

      Why is it not working:

       

       

        • 1. Re: Formula
          mara.quindoza

          Hello suvas.chandra,

           

          Just a question, what are you trying to return in here?

          Also can you attach a sample of your workbook?

           

          Thank you!

          • 2. Re: Formula
            suvas.chandra

            I have three sheets in the dashboard. I have created this parameter to filter data in three different sheets to satisfy four different scenarios:

             

            1) Grid 1, Graph 1, Graph 2

            2) Grid 2, Graph 3, Graph 4

            3) Grid 3, Graph 5, Graph 6

            4) Grid 4, Graph 7, Graph 8

             

            Workbook is attached.

            • 3. Re: Formula
              Mark Fraser

              Hi Suvas

               

              i note you switched the parameter from float to string - thats the first issue now, you need "1", "2" etc... doesnt matter though you have bigger problems...

               

              I think i see what you're trying to do,

              what i think you want to do - is display 3 graphs based on a single parameter - based on specific values - which are based on the parameter selection

              but it wont work in that way unfortunately - i think you'll get further with dashboard actions but even then its going to take some thought...

               

              You may need to define the report selections (somehow) first, and then use the result of this test in the paramater - kind of cascading the logic but not sure how much is possible

              Will give it some thought - i hope some of this makes sense, and helps you and others

               

              Cheers

              Mark

              • 4. Re: Formula
                Tom W

                Suvas,

                Your formula isn't formed correctly. Take a look at the help documentation for IF statements - Understanding Logical Calculations | Tableau Software

                 

                The correct logic for an IF statement is along the lines of

                IF [statement] THEN [result]

                ELSEIF [statement] THEN [result]

                 

                You are writing IF [statement] THEN [statement] AND [statement]

                It looks like you might be misunderstanding how a calculated field works - it does not assign a value to another field, it will return a value as per my sample above.

                1 of 1 people found this helpful
                • 5. Re: Formula
                  Mark Fraser

                  Thanks Tom - helpful explanation.

                   

                  From what I could work out, I believe the OP wants to pass values (for filtering the 3 graphs) based on selections via the parameter.

                  Kinda like dashboard actions, via an IF statement... inventive but dont think its going to work.

                  There must be a way to use the outcome of one function to pass a value and then filter another item (assuming so kind of hand-off or cascading) but havent given it too much thought, yet.

                  my gut feeling was that dashboard actions maybe better to drive the contents of the graphs via filters - thats essentially what the problem is

                   

                  Mark