How to Freeze Columns and Rows in Custom Grid Widget in Bold BI?
Freezing columns and rows in a custom grid widget in Bold BI can be a useful feature when working with large datasets. This feature allows you to keep certain data visible while scrolling through the rest of your data. Here’s how you can do it:
Step 1: Download the Custom Widget: First, you need to download the Grid Frozen Column custom widget. This widget is specifically designed to allow you to freeze columns in your grid.
Step 2: Publish the Custom Widget: After downloading the widget, you need to publish it to the Bold BI application. This will make the widget available for use in your dashboards. You can find a detailed guide on how to publish custom widgets here.
Step 3: Add the Widget to Your Dashboard: Once the custom widget is published, it will appear under the Miscellaneous section of the designer panel. From there, you can drag and drop the widget onto your dashboard and configure the data as needed.
Step 4: Enable Frozen Settings: After adding the widget to your dashboard, you need to enable the Frozen Settings. This is done under the property section of the widget. By activating the enable frozen settings option, you can freeze any column in the grid and specify the number of columns to be frozen. Please note that the grid index value starts with 1. After enabling the frozen option, the first column will be frozen by default. From there, you can make modifications as needed.
And that’s it! You have successfully frozen columns and rows in a custom grid widget in Bold BI. This feature can greatly enhance your data visualization and analysis capabilities.
References
