6 Replies Latest reply on Oct 16, 2016 6:46 PM by yafu li

    Table Elements Classification

    yafu li

      Hey all - need some help with the following :

      6~47G5Y8CHKEK]I8YPD93[V.png

      As the pic shows above. I want to classify 'Host:id's according to their rows below. The classification standard is as follows:

      1. with the value of 'vmklinux' equaling 1 but with that of 'native' euqaling 0

      2. with the value of 'native' equaling 1 but with that of 'vmklinux' euqaling 0

      3. with the value of both 'native' and 'vmklinux' equaling 1

       

      Note that both 'vmklinux' and 'native' are groups that contain many elements.

       

      Please let me know if you have any questions.

        • 1. Re: Table Elements Classification
          Sreekanth Kasaraneni

          hi yafu,

           

          please provide sample workbook.

           

          Thanks,

          Sreekanth.

          • 2. Re: Table Elements Classification
            yafu li

            Hi Sreekanth ,

             

            Thanks  for reminding. Yet, the data is company’s privacy so I’m afraid I am not authorized to do so.

             

            Best regards,

            Yafu Li

            • 3. Re: Table Elements Classification
              Sreekanth Kasaraneni

              Hi Yafu,

               

              if possible please provide only sample dummy mock up data.

               

              Thanks,

              Sreekanth.

              • 4. Re: Table Elements Classification
                yafu li

                Hi Sreekanth,

                 

                Things get a little complicated and I may need some time to make such a sample. Thanks very much for your help and hearty advice. I’ll inform at once when the sample is finished.

                 

                Best Regards,

                Yafu Li

                • 5. Re: Table Elements Classification
                  Sreekanth Kasaraneni

                  Hi Yafu,

                   

                  Using the give screen shot i tried to mock-up sample data and done some work.

                  please find the sample data file and workbook for your reference.

                   

                  to display Names i used below calculation@

                   

                  IF [Device Drive] = "VmkLinux"

                  and { fixed [Host ID] :sum(IF [Device Drive] = "VmkLinux" THEN 1

                  ELSEif [Device Drive] = "Native" THEN 1

                  END)} =1 then "VmkLinux"

                   

                   

                  ELSEIF [Device Drive] = "Native"

                  and { fixed [Host ID] :sum(IF [Device Drive] = "VmkLinux" THEN 1

                  ELSEif [Device Drive] = "Native" THEN 1

                  END)} =1 then "Native"

                   

                   

                  ELSEIF [Device Drive] = "VmkLinux" or [Device Drive] = "Native"

                  and { fixed [Host ID] :sum(IF [Device Drive] = "VmkLinux" THEN 1

                  ELSEif [Device Drive] = "Native" THEN 1

                  END)} >=2 then "VmkLinux & Native"

                  end

                   

                  Count values use similar calculation as shown below

                   

                  IF [Device Drive] = "VmkLinux"

                  and { fixed [Host ID] :sum(IF [Device Drive] = "VmkLinux" THEN 1

                  ELSEif [Device Drive] = "Native" THEN 1

                  END)} =1 then 1

                   

                   

                  ELSEIF [Device Drive] = "Native"

                  and { fixed [Host ID] :sum(IF [Device Drive] = "VmkLinux" THEN 1

                  ELSEif [Device Drive] = "Native" THEN 1

                  END)} =1 then 1

                   

                   

                  ELSEIF [Device Drive] = "VmkLinux" OR [Device Drive] = "Native"

                  and { fixed [Host ID] :sum(IF [Device Drive] = "VmkLinux" THEN 1

                  ELSEif [Device Drive] = "Native" THEN 1

                  END)} >=2 then 1/2

                  end

                   

                  finally i got as shown in below image

                  • 6. Re: Table Elements Classification
                    yafu li

                    Hi Sreekanth,

                     

                                    Sorry to reply you late. Thank you very much for your really generous help. I think it might work. Although I used similar method before and failed, there was a slight difference between your soluntion and mine. Your one reflected a better understanding of the elements’ attributes.

                                    But my Tableau Desktop was expired today and I had to ask company to activate it. Thus, it may take me sometime to apply your method into my workbook. Anyway, I really appreciate your sincere help in resolving my problems. And I’ll make you informed as long as I make some progress or encounter some problems.

                     

                    Thanks,

                    Yafu Li