How to Increase the default Column count in the Grid Grouping Widget

By default the Grouping Grid custom widget in Bold BI supports up to 30 columns. To enhance the column count in the Grid Grouping Widget, follow these steps to modify the widget configuration. This process involves updating the widget’s JSON file and source file accordingly.

Steps to Extend Column Count

1. Change File Extension:
   • Locate the .bicw file of your widget and change its extension to .zip. For further information, please refer to this document: Unpack the custom widget

2. Extract the Zip File:

   • Extract the contents of the newly created .zip file.

3. Edit the Widget Configuration:

   • Find the widgetconfig.json file within the extracted folder.
   • Open the file and search for the Alignment Settings Properties section.
   • You will see a list of 30 columns. You can add additional columns as needed.

   In the Alignment Settings Properties of the column section, it is possible to customize the number of columns displayed in your Bold BI dashboard. If you need to add a 31st column field, you can do so by modifying the JSON structure associated with the alignment settings.

   {
       "displayName": "Column Name",
       "controlType": "text",
       "name": "cn31",
       "defaultValue": ""
   },
   {
       "displayName": "Width",
       "controlType": "number",
       "name": "cw31",
       "defaultValue": 100,
       "min": 100,
       "max": 1000
   },
   {
       "displayName": "Header Text Alignment",
       "controlType": "enumeration",
       "name": "hta31",
       "defaultValue": "Left",
       "listItems": [
           "Left",
           "Center",
           "Right"
       ]
   },
   {
       "displayName": "Content Text Alignment",
       "controlType": "enumeration",
       "name": "cta31",
       "defaultValue": "Left",
       "listItems": [
           "Left",
           "Center",
           "Right"
       ]
   }
   

   
   
   
   
   • Ensure that you continue the numbering sequentially after reaching 30 (e.g., 31, 32, etc.).

4. Modify the Source File:

   • Open the sourcefile.js located in the src folder.
   • Update the static iteration value to reflect the new number of columns you are adding (e.g., change it to 31, 32, etc.).
   

5. Recompress the Files:

   • After making the necessary changes, select all folders and files, and compress them back into a .zip file.
   

6. Change the Extension Back:

   • Rename the .zip file back to .bicw.

7. Upload the Updated Widget:

   • Finally, upload the modified .bicw file back into the Bold BI application.

By following these steps, you can successfully increase the column count in the Grid Grouping Widget to meet your requirements. This is particularly useful for scenarios where additional data representation is needed, allowing for more detailed analysis and reporting.

Additional References

• How to use the hierarchical grid custom widget in dashboard
• Pivot grid widget
• Unique features of pivot table
• How to add a Grouping Grid Custom Widget to a dashboard?