Awesome, thank you for this!
Unfortunately, the font is still too big for the boxes. I have two ideas:
- All of the labels are Place names (States, or Countries). For the smaller boxes, I could replace the FULL name with a shortened version (like KY instead of Kentucky, or NL instead of Netherlands). How would I tell Tableau to do this?
- Could I have the font be bigger in the larger boxes? Could I tell Tableau to scale the font size down, depending on the size of the box?
I will prefer the 1st option. To achieve this, you can either join your data to a separate data source which has the mapping of the place names with the short name or create the calculation field to hard code the short name for each place. like
if place name = "XXX" then "X" elseif ..... end
Yes, you can use left() or right() function to get a length of 10 characters.