You can export an individual Visualization Card to a .csv file, a Microsoft Excel spreadsheet file, or a Microsoft PowerPoint presentation. You can also export all of the Visualization Cards in a Page to PowerPoint, with one Card appearing per slide. If you export a Page of Cards to PowerPoint, any non-visualization Cards may not be exported, such as Notebook, Document, or Sumo cards.
If you have filtered Card data in either the Page or Card Details view, those Filters remain in place when the Cards are exported. For more information about using Page Filters, see Applying Page-Level Filters. For more information about using Card Filters, see Adding Filters to Your Chart.
The exception to this is filters that have been set for the Card in the Edit view. These filters are considered implicit elements of the Card. Even if you modify these filters using the Analyzer, they will be retained in the exported version of the data.
Likewise, if data in a Card is filtered due to PDP policies, those Filters are applied in the exported version.
You can also export a Page of Cards as a slideshow in Domo and then download it as a Microsoft PowerPoint presentation. This is essentially the same as using the Export as PowerPoint option discussed in this topic but requires extra steps. However, it also provides additional options not available when downloading directly to PowerPoint. For more information, see Exporting Publications.
You can export a drill down layer of a Card as well. For more information on how to export a drill down, see Exporting Data from a Drill Path.
Notes:
-
When you export a Visualization Card to a Microsoft PowerPoint presentation, it appears as is, in its Card state. When you export a Card to Excel or CSV, only the data from the Card is pulled; graphical elements of the Card only appear when exporting to Excel.
- Files cannot exceed 4MB in size for export purposes.
- When exporting to Excel, only data that is displayed in the Card will be exported, up to 1M cells of data while exporting to CSV will output all rows. For Megatables, Pivot tables, and HTML tables, this is 50k rows by default and up to 100k rows by manually increasing the row limit inside of Analyzer.
- HTML tables are not limited to 1M cells.
- For Pivot tables, the limit is applied on the DataSet rows rather than the pivoted data rows.
-
When exporting a Table Card with aggregations grouping rows together, the data will remain aggregated. To see the raw data, you must remove the aggregation in your table first, then export.
-
Be aware that when you export Heat Map Tables to Excel or CSV, the exported data may appear differently than expected, as it renders to match the table view of the data, not the Card view. For more information about Heat Map Tables, see Table Chart. For more information about the table view, see Card Details View Layout - Table view.
-
You can use a spreadsheet or text editor application to open a .csv file to see the exported data.
-
When any user exports a Card, an event called "Exported DataSet" appears in the Activity Log in Admin Settings. This may lead to the assumption that the user who exported the Card has access to the DataSet, but this is not necessarily the case.
-
If your data contains a string data type column that contains only numeric values, such as zip codes, it will be exported with a single quote added to the beginning of every value in the column to prevent Excel from enabling their auto macro functionality. (e.g. '84084)
-
Both CSV and XLSX exports append a single quote on string columns displaying negative numbers. This is for security purposes, to prevent auto-macro functionality. If you remove the quotes, the cell values immediately become active macros.
Video - Filtering and Exporting a Card
To export a Page of Cards to PowerPoint,
-
(Conditional) If you want to filter data, use Page Filters to filter data in the Page.
-
In the
menu in the top right corner of the Page, select Export as PowerPoint.
The Page of Cards is downloaded to PowerPoint, with one Card appearing per slide.
You can export a single Visualization Card from either the Page or the Details view.
To export a single Visualization Card,
-
(Conditional) If you want to filter data, use Page or Card Filters to filter data in the Page or Card Details view.
-
Do either of the following:
-
(Conditional) If you are in the Card Page, mouse over the Card that you want to export, click
> Send / Export.
The Export dialog opens. -
(Conditional) If you are in the Details view, click
> Send / Export.
The Export dialog opens.
-
-
Select the option you want.
Depending on the type, options include Email, Print, Excel, CSV, or PowerPoint.
Comments
0 comments
Please sign in to leave a comment.