You can use the "View Data" option to display all of the data, then select all rows and then copy them into an empty excel sheet. Detailed steps:
1) Open or create a worksheet that displays data derived from all rows (i.e. with no filters active). Just dropping SUM([Number of Records] on a new sheet is good enough.
2) Select all marks on the sheet (ctrl-A) then right click on a mark and select View Data.
3) Go to the "Underlying" tab.
4) Select all rows in the grid (ctrl-A) and click the copy button.
5) Open Excel and paste the copied data into a new sheet.
thanks for your help. I just got stock at the first step. SUM([Number of Records]: how can I drop that on a new sheet?
Please apologize, I just started to use Tableau.
Create a new worksheet (just click the small icon to the right of the tabs for the existing sheets).
Then drag the field [Number of Records] and drop it on the text shelf, as shown in the picture.
The number of records in the extract will be displayed on the sheet. Just right-click on the number (I've highlighted 4284 in the screenshot) and select View Data from the menu.
I think it should be clear from step 3) onwards. Say if not.
thanks for your detailled answer. I experience one problem before the right click on the number:
The number of records in the extract is not displayed on the sheet. Do you probably know why this does not occur?
You will need to attach a screenshot of how your sheet and the shelves look.
Message was edited by: Richard Leeke: Corrected strange typos created by auto-correct on my phone.
You can also directly get to the excel file by 'unpackaging' the file.
Some operating systems allow you to right click a twbx file and select 'unpackage'..
But you can always rename a twbx file to a 'zip' file (which is what it is) and then open the zip file. You will find the Excel file inside the zip file.
What Tom said. But be aware that this doesn't work if the data is an extract (tde).
Definitely try Tom's way first. I just assumed it was a data extract.