1 Reply Latest reply on Oct 12, 2016 12:24 AM by ra.sae.0

    How to Group markets?

    Niranjan Banarjee

      Hi,

       

      I have got an instance where I want the geography Measure to club few countries based on parameter.

       

      Sample as below, where Group-1 is a parameter.on change of parameter the country in the line chart should change.

        • 1. Re: How to Group markets?
          ra.sae.0

          Hi Niranjan,

           

          Create a calculated field like this and Group Selector is just a Parameter with Values - Group - 1, Group - 2, Group -3.

           

          Add that Calc field to Filter and exclude Null.

           

          PFA Workbook.

           

          I guess we have simpler solution in Tableau 10 using Groups in calculated field (similar to the below formula I guess).

          I donot have access to Tableau 10 right now.

           

           

          Pls try the below option too. It works fine for me.

           

          Hope this helps.

           

           

           

           

           

          if ([Country] = "A" OR [Country] = "B" OR [Country] = "C" OR [Country] = "D") AND [Group Selector] = "Group - 1"

          then

          [Country]

          elseif ([Country] = "C" OR [Country] = "D" OR [Country] = "E" OR [Country] = "F") AND [Group Selector] = "Group - 2"

          then

          [Country]

          elseif ([Country] = "G" OR [Country] = "H" OR [Country] = "I" OR [Country] = "J") AND [Group Selector] = "Group - 3"

          then

          [Country]

          END