The Plot Thickens....
I'm now convinced this is a bug. A colleague of mine, Miroslav Licek found that if you apply the custom format on the measure value of the sheet (as opposed to the default property of the measure) the format is not exported giving the correct expected result. See the screen and v2 book attached.
This looks like a bug to me. Would anyone say otherwise?
He confirmed the same behavior in 9.3 and 10 (beta 2) as well.
Can we get this fixed Tableau? I don't want to apply the same format again and again on every sheet. This is why we have default formats to begin with.
Thanks in advance
Screenshot showing Amt-Custom Format 2 (format not applied as default) works
Amt_Raw_vs_Custom_Format-v2.twbx 27.8 KB
I have no idea, as I've not experienced this issue -- but you should certainly file a case with email@example.com any time you feel you've found a bug. You can also let the Beta team know about anything you see in V10, via the Beta feedback/Forums site.
There's no bug here. Sorry.
Tableau always shows numbers formatted in View Data. This is how you get currency as currency, percents as percents, etc.
Tableau always exports crosstabs data WYSIWYG. So if your data is formatted in the viz, it will be formatted on export.
If you choose Export > Data, then we export the raw data.
If it behaved the way you described, I would agree with you that there is no bug.
I understand exporting crosstab is WYSIWYG. I have no issue with that. In fact I like that.
My issue is when I Export > Data.... I do not get the raw data as you suggest.
Instead I get the formatted data which in my example eliminates values. Try it for yourself on the workbook I attached.
You can easily recreate it also.
In short, would you agree if Export>Data does not produce the raw data (simply because I've applied a default custom format) we have a bug?
John - I tried Export > Data on both Windows and Mac (Windows exports to Access and Mac to CSV) and got the raw data. So I'm not sure what problem you are seeing.
I think this will help.
Here are the steps to reproduce locally (without having to publish to server).
Analysis \ View Data \ Underlying \ Export All
On windows, a .csv file will be created with 251 rows of underlying data.
In reality both Amts are actually the same but they come out different on this .csv (this is the bug)
This simulates a user's results when they work with a published workbook and select either View Data or Download \ Data \ Full Data \ Download all rows as a text file
When you literally click Export \ Data from the desktop version, you're just getting the 2 row 'summary' (which does not have a bug).
The issue only occurs when getting to the 251 row detailed underlying data.
Hope this helps
Worksheet > Export > Data is the one that uses the unformatted data.
All the others are WYSIWYG and so use the formatted data.
Just to clarify, Export Underlying Data uses the Default Number Format of the field, Export to Crosstab uses the formatting of the view. For reference:
The change in underlying value when using Custom Default Number Format, that I need to look into more.
Hope this helps