The custom bar 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. 

The dashboard designer canvas opens on the new page. Drag the Custom Bar Chart Widget from the toolbox to the designer canvas. Click on the Edit icon to configure. 

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 bar chart algorithm.  Use the $dateFilter (wildcard syntax) in the Where condition and an appropriate date column reference. Select the bar chart orientation (vertical or horizontal). Select the chart result type (number or percentage). Select the colors from the drop-down list for the chart heading, body, and legend text. Click on the Save button to confirm the changes. 

On the dashboard designer canvas, select the UI - Preview menu option to view the dashboard. 

The custom bar chart widget dashboard is displayed on the new page. 

Use the date filter to render the chart to a different timeline. Hover the mouse on the bar to view the legend text. 

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

Refresh the FlowWright Dashboard page to view the new dashboard in the left pane, as shown below.