Forum Discussion
Export data doesnt match
The data that gets exported is the UNDERLYING data used in the visual, not necessarily in the exact format that the visual is showing it. For example, if you have a matrix with a hierarchy on the rows and columns and you expand all to the bottom level, when you export you won't get a table with the same structure.
We are having the same problem, and understand that the underlying data will be in a different format than the visualization. That is not the issue.
We have exported the underlying data to a visualization, and added up the numbers in the extract. The totals obtained from the extract do not match those shown in the visualization. The viz is correct and matches our database totals, but the exported data is not. It seems to be a problem in the export function itself.
This is a problem for us, in that our users are exporting data from visualizations as part of User Acceptance Test. They want to verify that the totals and calculations shown match the underlying data.
Until the Export Data feature can be investigated, it seems that it is unreliable, and should not be used for testing values.