Hello,
I am trying to export data from dashboards. The exported data does not correspond to what I see in a graph. It seems that numbers are completely different. It probably exports underlying data and not 100 % stacked data.
I am attaching pictures as evidence.
Thanks a lot
Hello Anastasie,
Exporting a visualization in XLSX format will always show the underlying data in tabular format. If you wish to see the graph instead, you will need to place the insight in a KPI dashbaord and then export it in PDF format. More details about the export options can be found in our documentation here: https://www.gooddata.com/docs/cloud/create-dashboards/export/#pdf
-Moises
Hello Moises, than you for explaining. I undestand that it shows only underlying data, but could why is data format in % then?
You’re welcome. Please note the insight format is also applied to the exported file.
Underlying data is in numeric format such as 2 135 856, but it shows 2 135 856% which is to my understanding incorrect.
If you wish to remove the formatting, it can be done from the insight metric format menu as specified in the documentation: https://help.gooddata.com/doc/enterprise/en/dashboards-and-insights/analytical-designer/work-with-metrics/format-numbers/#FormatNumbers-Definecustomnumberformats
Thank you for explanation
Hello
I created a 100% stacked area chart and set up the format to Percent (rounded).
When exporting data to Excel, the data has a percent format, but it is applied not to the market share shown in the chart, but instead to the underlying data.
If I want the underlying data to have the correct format, I need to set the format to default, which is a 2-digit %. However, I want the market share to be rounded to the nearest percent.
Therefore, I can't export the data with the proper format without compromising the look of the chart.
Is there any way around this? thank you
Hello
All in all, XLSX exports work best with tabular insights, therefore, could you try creating a table insight instead and export it? Are you still having issues with the resulting export? If you wish to export a stacked area chart, it is better if you use the PDF format.
-Moises
Sign in with your community account. This is different than your login to your GoodData account. Don't have a community login? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
