I've been working with TREE MAPS and have been puzzled when it comes to sorting.
I have a simple file (see attached) of Cats/Dogs and their different names, along with the amount of hugs they get per month. (my ACTUAL file has many, many more partition layers)
I've set up my first partition ( [Animal]) so that my Cats are kept separate from my Dogs (we can't have them mixing).
Cats are on the left, Dogs are on the right.
The problem occurs when the partition size of "Dogs" exceeds the partition size of Cats-- the order is then REVERSED, with Dogs on the left, Cats on the Right.
Is there a way to control this behavior, or is this a result of the same sorting that puts the biggest "box" in the upper left corner? Many thanks for anyone with a solution!
@Jim Dehner FYI 😁
@Robert Breen and @Soumitra Godbole :
Thank you both for your contributions. And though I hate to end the year on a downer, sadly...
- The separate sheets was an option I considered, however, the left/right sides do not remain proportional to one another. In other words, Cats might be 10x the size of Dogs one month, but Dogs might be 10x the size of Cats in the other. Side-by-side will show proportional breakdowns within that partition, but not against the neighboring partition 😕
- The stack-bar is a nice approach and would work if I just had 4 animals total. However, in my ACTUAL view I'm looking at perhaps 60 different items, which means those pieces become slivers far too thin to read (let alone hover over).
The best solution I came up with: adding a button that switches between Cats and Dogs and not giving the view an option of seeing them both at the same time. This frees up more space for my viewers to explore those smaller pieces. It ain't perfect, but they seem to like this option more than the "unreliability" of it switching sides.
Just for fun-- what happens when we create Tree Maps using negative values? Do they sort in reverse order? Sounds like an experiment!
I'll leave this question open in case anyone else has a solution for keeping Cats away from Dogs.
