How to export underlying data of the widget instead of summarized data
When you export the widget data using the Export option, the exported Excel or CSV file will contain the summarized data.
You can export the underlying data of the widget to a CSV file or an Excel file using the View Underlying Data
option in the Bold BI application.
Follow these steps to export individual rows of widget data:
-
After configuring the widget, enable the
View Underlying Data
option from the Container Actions properties section.
-
Select the View Underlying Data menu item from the highlighted option below.
-
By default, the pop-up grid will display the columns that are configured for the selected widget. Click on the
Export
icon to export the data as a CSV or Excel file.
-
Additionally, you can enable the Show all columns option to view and export all the columns of the data source that is configured to the widget.