Tableau: Is there a quick way using Tableau to look at multiple dimensions with one field?

Category:
Question ID: 109678
0
0

Hi,

I am trying to review multiple dimensions in my Tableau workbook using one field do you have any solutions?

Thanks,

Gracy

Marked as spam
Posted by (Questions: 10, Answers: 3)
Asked on July 20, 2020 5:59 pm
5 views
Answers (1)
0
Private answer

Hi Gracy,

You can easily review all your dimensions by creating a parameter and a parameter filter to switch between each of your desired dimensions.  We will first build the parameter.

  1. Select create parameter from the down caret to the right of Data on the upper left side of the screen.
  2. Name the parameter “Select Dimension” and change the format to “String” and “List”
  3. Add each dimension on the left and the name will copy to the right side of the list. You can change what is seen when you view the parameter on the right side of the list (see image).

Select Dimension

String

List

Value: Name of Dimension           Display As: Name I want my users to see

Region                                                  Region

Category                                              Category

Product Name                                   Product

  1. After you create your parameter, you can now create your filter which is a calculation that uses a “CASE” statement.
  2. Right-click on the parameter “Select Dimension” which is now under Parameter on the left bottom of your screen, to build out your calculation (see image).

“Select Dimension Filter” calculation

CASE [Select Dimension]

WHEN “Region”                   THEN [Region]

WHEN “Category”               THEN [Category]

WHEN “Product Name”     THEN [Product Name]

END

  1. Drag the “Select Dimension Filter” on the row shelf, right-click and show filter
  2. Right-click the “Select Dimension” parameter, and show parameter
  3. Add any measured value to the column or text on the marks to review output.

Note: If one of the “Select Dimension Filter” is a Null go back to your calculation and/or Parameter to ensure the name is spelled correctly.

Happy Tableau-ing!

Attachments:
Marked as spam
Posted by (Questions: 3, Answers: 10)
Answered on July 21, 2020 11:01 am