4 Replies Latest reply on Sep 29, 2018 11:37 PM by Allen Isom

    Venn Diagram

    Kary K

      Hello All,

       

      I have a static Venn Diagram. I just need to display the values on the static Venn Diagram.

       

      I need to calculate the respective values.

       

      Attached is the .twbx workbook.

       

      I have Category, Id and amount fields. I could calculate the Lily and Violet amounts.

       

      Please help me calculate the other values specially the intersection of both.

       

      Thanks,

      Kary!

       

      Your help is much appreciated.

        • 1. Re: Venn Diagram
          Hari Ankem

          I made changes to your formulae and here is what I have now:

          1.png

          1.png1.png

          1.png

           

          Hope this helps.

          • 2. Re: Venn Diagram
            Kary K

            Hi Hari,

             

            Thanks so much for your response.

             

            I tried to work this out on my data set but it doesn't work.

             

            I've now attached similar kind of data set i have. Please let me know if a solution is possible for this.

             

            The Result set i'm looking for: Total Lily: 232

                                                            Lily Only: 58

                                                            Total Violet: 114

                                                            Violet Only: 63

                                                            Lily+Violet:225

                                                            Total(Lily+Violet)= 346

             

            I'm new to LODS. I have tried various LOD formulas since 2 days. Nothing works for me.

             

            Your help is much appreciated.

             

             

             

            Thanks,

            Kary.

            • 3. Re: Venn Diagram
              Hari Ankem

              I don't think you can get the expected output you want, especially when your data does does not support it. Look at your pivoted data below.

              1.png1.png

              • 4. Re: Venn Diagram
                Allen Isom

                Here's a simple one I made.  You can change the shape type to Circle and it would work just as well. I added a custom shape for fun. You can add the Size, X, and Y into your data or you can make a case statement to assign the values.

                 

                Many other solutions involve plotting and drawing custom polygons in Tableau but that can slow performance sometimes and get fairly complex. This one is easy peasy.

                 

                Hope this helps.

                 

                https://public.tableau.com/static/images/Ve/VennDiagram_7/SimpleVennDiagram/1.png