10-28-2016 07:55 AM
That's so strange. My file on this end says "don't summarize" is selected. Your code won't run because it doesn't like the (perfectly good) file path, and it says duplicate rows have been removed from the data, which isn't supposed to happen.
This visual appears to give incorrect results when 4 fields are selected.
I can do 3 just fine but 4 doesn't calculate properly, e.g., a category with 30 items shows 20, 4, 0, 0 instead of adding to 30.
My math could be off, though. I think with 4 categories there's no way to actually show the top & bottom categories (or left & right) intersecting since they already overlap in the middle. Maybe that's just a limitation of Venn diagrams; in that case maybe limit it to 3 categories?
The rows are unique; I was using an illustrative example but I was using the diagram on a real dataset which has a row ID type field and I was still having problems with the 4 dimensional Venn diagram.
The issue is likely something to do with more than 3 categories requiring strange diagrams:
The visual doesn't make the 4th category into that "rainbow" type thing, so the math might be off.
Or I might be wrong.
Either way for now I'm sticking with 3 categories as the math works out in that diagram.