How to increase Column Limit in Classic Layout Pivot Grid Custom Widget?

Increasing the column count in the Classic layout pivot grid custom widget allows users to display more data in a structured format, enhancing the analytical capabilities of the dashboard. The default maximum number of count is set to 10. If we attempt to add a 11th column, it will replace the most recently added column. You can modify the maximum limit from 10 to your desired value. Increasing the column count is beneficial for scenarios where users need to display a variety of metrics side by side for comparative analysis. Follow the steps below to adjust the column count:

Steps to Modify Column Count

Please find the custom pivot widget attached in this article.

Step 1: Rename the File:

• Change the file extension of the .bicw file to .zip.

Step 2: Extract the Zip File:

• Unzip the renamed .zip file.

Step 3: Edit Configuration:

• Open the widgetconfig.json file and adjust the maximum column count in the Values section, Column or Row Section. The default maximum is set to 10, but in this instance, the number of counts has been raised to 12.
  
  
  
  Before changes:
  
  
  
  After changes:
  
  

Step 4: Download Utility:

• Download the utility from the following link and run the executable file:
  Bicw Utility

Step 5: Pack the Widget:

• Execute the below command:

  pack <location of the extracted custom widget folder>
  

Step 6: Output:

• The custom widget will be created in the output folder, and you can now upload the modified custom widget in the Bold BI application.
  
  

Additional References

• Add a grouping grid custom widget to a dashboard
• How to use the hierarchical grid custom widget in dashboard
• Pivot grid widget
• Unique features of pivot table