Articles in this section
Category / Section

How to Show the Raw Data in the Grid widget

Published:

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.

image.png

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

image.png

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.

image.png

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

image.png

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.

Additional References:

Was this article useful?
Like
Dislike
Help us improve this page
Please provide feedback or comments
GR
Written by Gayathri Ravichandran
Updated:
Comments (0)
Please  to leave a comment
Access denied
Access denied