I’ve known for several years that Google Sheets is the only data source which Tableau Public can automatically refresh for users. Until a few weeks ago, I had never tried to set up a living connection between Tableau Public and a routinely updated Google Sheet. It turns out that Tableau Public is good at holding up it’s end of the bargain, but keeping Google Sheets updated isn’t as simple.
All tagged Google Sheets
LISTAGG is a powerful SQL command to denormalize rows data.
But, what if you don’t have access to SQL or just need a quick way to accomplish this?