1) Select All, then Copy Data (or Ctrl-A Ctrl-C). You *do* have to then paste in your choice of a text or Excel file.
4) After putting a measure on Color or Size shelf, open the Edit Colors / Edit Sizes dialog, where you can freeze/fix the start & end of the range.
2) Interesting. I think that's a request I've never heard before.
3) We've played with this a bit. Would take a fair amount of work to do it right, but we may go there someday.
I appreciate your thoughts!
Thanks, James, for your post. Your suggestion for point 1 above I took to mean that after copying the data in a view, I could open a new text file (I use EditPlus) and then paste the data in and then save it as a CSV. When doing this, I get a tab delimited listing of the data in the view with the field names (also tab delimited) in the first row. This should work fine - thanks for the tip - and I see that bringing up the underlying view of the data could address my question in a different way - factor of course is whether or not the non aggregated underlying data would all fit in the clipboard. Your tip re: my point 4 above looks to address my request as well, thanks. In another post I discussed allowing any modal dialogues Tableau puts up in various contexts to be re-sizable (esp. to be able to make them wider). This would be especially helpful when connecting to data sources (which are named based on table names) and sometimes table names get long based on the business meaning of a table, etc. Thanks for considering points 2 and 3 above - point 2 would be really useful as the context added to a measure via color, size, path, and shape really enhance the "intellectual capital" of a pile of numbers. Best wishes, Michael
Oh yeah, that gets copied out in TSV and not CSV - point taken. The reason is Excel, and being Excel-compatible. So there really is no CSV get data, I wonder if that was on purpose...
Tab delimited is compatible with just about all major db platforms - csv would be nice as must folks work with CSV files quite often - having said that, tab delimited also works. Will admit that my long term memory is not perfect, but I seem to remember that early versions of Tableau Desktop (1, 1.5, or 2) supported CSV export. Best Wishes, Michael
+1 for CSV export.
What would be *really* nice on the export front is all of these options:
* Export to file (CSV etc rather than just Access) from the file menu (so avoiding clipboard size limits)
* The option to export either the aggregated data or the underlying rows
* Option to copy as CSV or TSV on copy to clipboard
* Inclusion of calculated field values in the export option (as per the Copy Data and View Underlying Data)
I don't want much, do I?
Also +1 for resizeable dialogs - I always end up cutting and pasting my great long file paths and custom SQL to and fro into a text editor so I can see what I'm doing.
Colleagues: Thanks for the comments since my initial posting. One place where a size able modal dialog would really help is when defining joins between tables (Data ----> Tables). The current non size able dialog often doesn't allow you to see the full column names that have been joined. Also when opening a workbook - if you have many workbooks in the directory you're browsing, a size able dialog would save much scrolling, etc. and make it easier to find a workbook via sorting as many more workbooks would be visible if you could make the file / open dialog much larger. Michael
Bump on this, our clients use the data we show them from our RDMS and filter down etc to a view of data they want ran through a separate process we do for production processing. If >CSV was there, it would make our lives much easier.
The request has been for a while since Sep 2009: export csv from underlying rows (do not need copy to clipboard). The feature already there on Server (download csv data). I wonder why this is not available in Desktop. Hope this is provided in upcoming T8.