1 2 Previous Next 16 Replies Latest reply on Jun 14, 2011 10:04 AM by Alex Kerin

    Feeding what goes on rows and columns shelves via a parameter

    Steve Wexler

      Folks,

       

      Andy Contreave has an excellent post about user created views at

       

      http://www.thedatastudio.co.uk/blog/the-data-studio-blog/andy-cotgreave/user-built-views

       

      I need to expand a bit on this idea as I have about 100 measures and I want to create a scatter plot that compares one measure against another by selecting the X-axis measure and Y-axis measure from a parameter drop down.

       

      One method that Andy exploits is to create a calculated field that looks like this:

       

      IF [Choose bar] = "Sales" then Sales

      ELSEIF [Choose bar] = "Profit" then ([Profit])

      ELSEIF [Choose bar] = "Shipping Cost" then ([Shipping Cost])

      ELSEIF [Choose bar] = "Unit Price" then ([Unit Price])

      ELSEIF [Choose bar] = "Order Quantity" then ([Order Quantity])

      END

       

      My issue is that I don't want to create a conditional test for the 100 possible measures.  Now, the parameter strings and the measure names are identical. With this in mind, is there any way to tell Tableau to take

       

      "Profit"

       

      and turn it into

       

      [Profit]

       

      ?

       

      Note that the approach I hope to use works fine with dimensions.

       

      Steve

        1 2 Previous Next