1 of 1 people found this helpful
This could be a good opportunity to use Tableau Prep to try to manipulate the file and make it row-based data with one tenant per line, which is what you really want to do packed bubbles. If you can import the original file into Excel and do a split on Tenants column to get the three separate columns, save that as CSV.
Connect to that CSV in Tableau Prep and do a pivot on those Tenant fields to get your row-based data. I did something similar today with a column-based data set. When you create the pivot in Prep you would use only the split tenant fields in the pivot and the other fields for Property and Address would be replicated properly to each row. The pivot basically says "take each column you designate in the pivot and create a row with that value, and replicate the rest of the data to the row".
Property Address Tenant A 111 5th Ave Wendys D 1114 12th Ave Dry Cleaner D 1114 12th Ave Liquor Store D 1114 12th Ave Starbucks
I don't have any experience using Tableau prep. Any other recommendations?
Not good ones off the top of my head. I was thinking LOD calcs but it was ugly in my head. With Tableau in general row-based data is much easier to work with. If you can get it in the correct state, it makes life much easier.
I used Prep for the first time today after watching the 4 minute video on Pivots. Took about half an hour to get it sorted on a 302 column based file that I needed to make row-based. It looks and feels a lot like Tableau Desktop if you are using Desktop already. You can save the flow you create so that if you were updating this dashboard regularly you can load the new file, run the same prep and output the same file. You can even have Prep create a HYPER or TDE file for you that you can connect to directly in Tableau Desktop.
It seemed ugly in my head when I was trying to think it through as well. I'll take a look into Tableau prep to see if I can get it figured out. Thanks for the help!