Using a Custom PivotChart Widget in Bold BI
A PivotTable can be utilized to summarize, analyze, explore, and present data. PivotCharts enhance PivotTables by providing visual representations of the summarized data, enabling easy comparison, pattern recognition, and trend analysis. In scenarios where there is a need to compare multiple drill-downs in a column chart, the custom pivotchart widget in Bold BI serves as an effective solution. This article provides a step-by-step guide on how to create and publish a custom pivotchart widget.
Prerequisites
- Download the custom pivotchart widget from the attachment section.
Steps to Add the Custom Widget in Bold BI
-
Publish the Custom Widget:
- Follow the instructions provided in the Bold BI Help Documentation to publish the custom widget to the Bold BI application.
-
Locate the Widget:
- Once published, the Custom PivotChart Widget will appear under the Miscellaneous section of the designer panel.
-
Add Measure Columns:
-
Add one or two columns to the Value data field and one or two columns to the Row data field.
-
Note: Currently, you can assign up to 2 values in both the Value and Row fields, and one column in the Column data field.
-
-
Rendering the Custom PivotChart:
-
The Custom PivotChart Widget will be rendered, allowing for the expansion and collapse of columns.
-
Expand and Collapse Features
PivotCharts are also interactive. The custom pivotchart widget enables users to expand and collapse columns at various levels, facilitating comparisons across different categories, such as cities from different countries.
- To use the expand or collapse feature, click the + or - symbol near the axis labels.
- Before Expand
- After Expand
Conclusion
By following the outlined steps, users can effectively visualize data in a custom pivotchart widget in Bold BI. This functionality allows for a more customized and meaningful visualization of data, particularly when comparing multiple drill-downs.
Additional References
