How to Show the Raw Data in the Grid widget
Displaying Raw Data in the Grid Widget of Bold BI
When working with the Grid widget in Bold BI, you may want to display the data without any grouping applied to the columns. This can be useful for analyzing the raw data as it is stored in the data source. Here’s how you can configure the Grid widget to show ungrouped raw data.
Steps to Show Raw Data in the Grid Widget
Step - 1: Add Columns to Measures and Dimensions:
Begin by dragging and dropping the desired columns into the Measures and Dimensions fields within the Grid widget.
Step - 2: Understand the Default Behavior:
By default, the values of the selected columns are grouped. This is the initial state before you select the option to display raw data.
Grouped columns in grid widget
Step - 3: Enable the Show Raw Data Option:
To display the raw data, go to the properties panel of the Grid widget. Here, you will find an option called ‘Show Raw Data’ within the Basic Settings. Enable this option to proceed.
Enable the Show Raw Data option in the Basic Settings.
Step - 4: View Ungrouped Raw Data:
Once the ‘Show Raw Data’ option is enabled, the Grid widget will refresh and display the columns of ungrouped raw data.
Ungrouped columns in grid widget
When the ‘Show Raw Data’ option is selected, any aggregation that was previously applied to the data is removed, allowing you to view the data in its most basic form.