I have a tableau workbook that was given to me. I open it and I see everything there.
I want to export the data to CSV including the measures which are a bunch of sums. Right now the measures are in the right 4 'colummns' but not in the column shelve.
How do I get it out into CSV format clean so that I can push it through R. This is driving me nuts...
Best How To :
To keep things clean, and save processing power, what I like to do in cases like this is drag all the dimensions and measures to Detail, instead of rows or columns.
I choose the Bar chart manually first. That way, Tableau won't waste time processing a visualization for the data. But the data will still be there, you can right click on the "phantom" chart, and select View Data. All is there. What is also there is an Export button, that will export to a csv.
If you have Tableau Server, you can use tabcmd to export this data to a csv.
tabcmd export "worksheet-name" --csv