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
I'm new to LODS. I have tried various LOD formulas since 2 days. Nothing works for me.
Your help is much appreciated.
VennDiagram-1.twbx 26.7 KB
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.