1 Reply Latest reply on Jul 12, 2012 7:04 AM by Jonathan Drummey

    Groups of dimensions

      I am visualizing a data set primarily developed for econometric research. Because of this, we have a series of about 20-30 dimensions that are dummy variables and describe various observation characteristics. The dimensions overlap so there is no way to combine into a single dimension. I'd like to use these to create a bar graph of percentage of positive responses for inclusion in a dashboard. Because of the large number of variables, I'd also like for users to be able to filter the graph by preset groups of 3-5 dimension. The groupings are thematic in nature. I've tried to play around with parameters and the like but havent had any luck. The closest I've gotten is creating a parameter that selects the predetermined groups. Depending on what group is selected, a calculated field for each dimension returns either the correct values or a NULL value. I was hoping that I could then filter out NULL values so that only the populated dimensions would be graphed but all i can get is a filter that kills the graph when the filters for different groups conflict. I guess my question is A) is there a way to filter out the NULL dimensions and B)am I going about this the wrong way altogether. http://public.tableausoftware.com/static/images/SC/SCCDataBaseWebPortal/Sheet19/1.png

        • 1. Re: Groups of dimensions
          Jonathan Drummey

          Hi Chris,

           

          It sounds like you're going about it in the general right way, I don't have enough information to give you much on how to do this so I set up an example of how I'd approach this. There's a parameter to choose the group and then a calculated field that looks like the following:

           

          CASE [Choose Group]

          WHEN 1 THEN

              IF [Sub-Category] = "Appliances" OR [Sub-Category] = "Binders and Binder Accessories" THEN

                  [Sub-Category]

              END

          WHEN 2 THEN

              IF [Sub-Category] = "Bookcases" OR [Sub-Category] = "Chairs & Chairmats" THEN

                  [Sub-Category]

              END

          WHEN 3 THEN

              IF [Sub-Category] = "Appliances" OR [Sub-Category] = "Bookcases"

              OR [Sub-Category] = "Computer Peripherals" THEN

                  [Sub-Category]

              END

          END

           

          That field goes on both the Colums Shelf and on the Filter Shelf, filtering for Null values, as in the attached.

           

          Jonathan

          1 of 1 people found this helpful