The semi-donut widget can fetch data through a database connection and SQL query, then display the chart using the results.

Navigate to the Manage > Dashboards page. 

Click the Actions > Create menu option on the Manage Dashboard page to create a new dashboard. Provide the dashboard name and display order number. 

The dashboard designer canvas opens on a new page. Drag the Semi-Donut Chart Widget from the toolbox onto the designer canvas. Click the Edit icon to configure it. 

The Configure Widget UI properties are shown in the pop-up window below. Enter the title name. Choose the database connection from the drop-down list. Provide the correct SQL SELECT syntax for the semi-donut chart algorithm. Use the $dateFilter (wildcard syntax) in the WHERE condition and an appropriate date column reference.  Click the “Test Query” button to validate the SQL SELECT syntax. Select colors from the drop-down list for the chart heading and body text. Select the checkbox to show the “header”. Click the Save button. Note: On the Manage Dashboard page, go to the Utils - Date Filter On/Off menu to toggle the date filter for this dashboard definition. 

On the dashboard designer canvas, choose the UI > Preview menu to view the dashboard. 

The custom semi-donut chart widget dashboard appears on the new page. Hover over the pies to see the legend text.

To view the dashboard in the menu pane, select Utils > Show/Hide on the dashboard designer canvas. 

Refresh the FlowWright Dashboard page to see the updated dashboard in the left pane, as shown below.