The custom pie chart widget can retrieve data using a database connection and an SQL query and display a bar chart from the resulting data.
Navigate to the Administration—Dashboards page. Click on the Actions—Create menu option to create a new dashboard. Give the dashboard a name and display the order number.
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/8802/direct/1716467586706-image.png)
The dashboard designer canvas opens on a new page. Drag the Custom Pie Chart Widget from the toolbox to the designer canvas. Click on the Edit icon to configure it.
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/8802/direct/1716467712211-image.png)
The Configure Widget UI properties are displayed in the popup window below. Provide the title name. Select the database connection from the drop-down list. Provide the appropriate SQL Select syntax for the pie chart algorithm. Use the $dateFilter (wildcard syntax) in the Where condition and an appropriate date column reference. Select the colors from the drop-down list for the chart heading and body text. Click on the Save button to confirm the changes.
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/8802/direct/1716474666167-image.png)
On the dashboard designer canvas, select the UI - Preview menu option to view the dashboard.
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/8802/direct/1716474993861-image.png)
The custom pie chart widget dashboard is displayed on the new page. Hover the mouse on the bar to view the legend text and click on the pie to extract a 3D view.
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/8802/direct/1716475015594-image.png)
Use the date filter to render the chart on a different timeline. Hover the mouse over the bar to view the legend text, and click on the pie to extract a 3D view.
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/8802/direct/1716475042406-image.png)
To view the dashboard in the menu pane, select the Utils—Show/Hide option on the dashboard designer canvas.
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/8802/direct/1716475242075-image.png)
Refresh the FlowWright Dashboard page to view the new dashboard in the left pane, as shown below.
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/8802/direct/1716475333453-image.png)