2 Replies Latest reply on Mar 19, 2015 11:21 PM by Tableau kumar

    Use of "Primary Group" in calculated field

    Rajdeep Panchal

      I have created Primary Group using data blending.

       

      I want to know if it is possible to use Primary Group in calculated field or parameter?

       

      I am not seeing these group when I create calculated filed

       

      Can anyone guide me if this is possible and how to use it?

       

      Thanks

        • 1. Re: Use of "Primary Group" in calculated field
          Catherine Denmeade

          Hi Raj -

           

          Is 'Primary Group' actually a group (aka - you created a group, it's not just a dimension called Primary group)?

           

          If it is a group, you can't use it in calculated fields. But, you could use a calculated field to mimic your group and then use that in another calculation.

           

          eg:

          IF item = 'xxxx' or item = 'zzzz' THEN 'group category 1'

          ELSEIF item = 'yyyy' or item = 'aaaa' THEN 'group category 2'

          etc etc

          • 2. Re: Use of "Primary Group" in calculated field
            Tableau kumar

            Hi Raj Panchal,

            I Think the following approach will help you.

            -----

            Customizing the Quick Filter using the Filed which is coming from Database.


             

            Customizing the Quick Filter using the Filed which is coming from Database.

             

             

            I have created Territories using "Regions" then I added Territory to 1st Report & I am implementing Territory filter for 2 Reports on the Dashboard.

             

            1) Created Territory field by using Regions.

            1.png

             

            2.png

             

            2) I added "Territory" to the View & applied quick filter on that.

            3) I added two reports to the Dashboard,And i applied this quick filter to both reports on the Dashboard.3.png

             

            4) Now we can notice that "How Quick Filter has been customized".

             

             

            4.png

            ===

            5.png

            Best Regards

            Laxman Kumar