1 Reply Latest reply on Jan 8, 2019 4:33 AM by Simon Runc

    Tableau Detail

    Shashank Kumar

      I have total users as 100 and the data goes as follows

       

      User A   Yes

      User B   Yes

      User B   No

      User C   Yes

      User D  No

      User E   Yes

       

      and so on..

       

      I want it to convert it to something like this

       

      User A   Yes

      User B   Yes

      User C   Yes

      User D  No

      User E   Yes

       

      In case of both Yes and No for a user out put should be Yes. whats the best way for this conversion. I already used countd for this but not able to filter the data properly for total count

        • 1. Re: Tableau Detail
          Simon Runc

          hi Shashank,

           

          So one way would be to pick up the Max of Yes/No (once converting to 1/0) and then use an LoD

           

          Something like

           

          [Yes/No Convert to 1/0]

           

          IF [Response] = 'Yes' THEN 1 ELSE 0 END

           

          Then use this as the Yes/No Dimension (using a COUNTD on User as you've done)

           

          {FIXED [User]: MAX([Yes/No Convert to 1/0])}

           

           

          Let me know if that doesn't do the job, or doesn't make sense.