Hey Aaron--this is neat. Can you explain the X and Y axis calcs, and your general process for developing this?
Yes, very clever.
From what I can tell, the X axis on the Column shelf separates the two columns:
IF INDEX()<=ROUND(SIZE()/2) THEN 1 ELSE 2 END
Computed w/ State
So, if the number of the State row (index) is less than the total # of State rows of/2, AKA, if it's in the first half, then it gets a 1. If it's greater, AKA in the second half, it gets a 2. This creates the two column values. They can be any number, as long as they're both different. Without them, each row of 2 states would be squished together.
The Y axis on the Rows shelf creates the rows for each state:
IF INDEX()<=ROUND(SIZE()/2) THEN INDEX() ELSE INDEX() - ROUND(SIZE()/2) END
Like the first calculation, if the number of the State row is in the first half, then it uses its index as the row value. If it's in the second half, then it subtracts the halfway row # from the index, and uses THAT as the row value. This aligns it with a State from the first half. Without this, there would be 2 columns of 12-13 states each, squished together.
All you have to do beyond that is sort the State by whatever value.
Yes Michael is correct. Make sure to compute both table calcs at the level of the dimension that you are showing and have that dimension on the text mark detail with right alignment.
Sent from my iPhone