The custom line chart widget can fetch data through a database connection and an SQL query, then display a bar chart based on the retrieved data.

Navigate to the Manage > Dashboards page. 

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

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

The Configure Widget UI properties are shown in the pop-up window below. Provide the title name. Select the database connection from the drop-down list. Enter the correct SQL SELECT syntax for the line chart algorithm. Use the $dateFilter (wildcard syntax) in the WHERE condition and include an appropriate date column reference. Choose the colors from the drop-down list for the chart heading, body, and legend text. Click the Save button to confirm the changes. 

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

The custom pie chart widget dashboard appears on the new page. 

Use the date filter to display the chart over a different timeline. Hover the mouse over the bar to see the legend text. 

To view the dashboard in the menu pane, choose 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.