5 Replies Latest reply on Mar 17, 2016 7:25 PM by Shivang Desai

    Not able to categorize data in 2 different groups

    Shivang Desai

      Hi Everyone,

       

      I am a bit confused in categorizing data in 2 different groups such that every mark used will have its own group.

       

      Example:

       

      My worksheet has 2 marks , one mark is used for Verified users and another for Non verified users.

       

      Attached are the screenshots:

       

       

      MARK 1

      Screenshot (40).png

       

      MARK 2

      Screenshot (41).png

       

      So here I have used Tableau concept of marks. What I am trying to do here is in the first pie chart just keep "Verified" users who are live, lapsed, dormant; in the second keep the Non verified members who are Live, Lapsed and Dormant. 

       

      But I am not able to do this. In screenshot 1 , I tried to use Verified Members for MARK 1 and it uses Live Registered Member. In screenshot 2, I used Non Verified members for MARK2  and it uses Non verified members.

       

      The calculated field for both is as follows:

       

      Live Registered Member

       

      IF [Verification Status] = "Verified"
      Then [Lapsed Grouping]
      ELSE
      NULL
      END

       

       

       

      Live Registered Member Non verified

      IF [Verification Status] = "Non verified"
      Then [Lapsed Grouping]
      ELSE
      NULL
      END

       

      As I have used each of them in separate marks, it should give me in 2 pie charts, but its mixing verified and un verified members as you can see in the above screenshot.

       

      The Lapsed Grouping is a calculated field which tells us whether a member is live, dormant or lapsed and the calculated field formula is :

       

      IIF(isnull([MonthDiff]),"Members who have not transacted",iif([MonthDiff]<=3,"Live Members (3 months or less)",IIF([MonthDiff]<=6,"Lapsed Members (Between 3 to 6 months)","Dormant Members (6 months +)")))

       

       

      How can I achieve separate categories. Please help me.

       

      Kind Regards,

      Shon