The SQL Gauge widget fetches data through a database connection and SQL query, then displays 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 SQL Gauge 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 gauge type between “label and number”. Choose the database connection from the drop-down list. Provide the correct SQL SELECT syntax for the SQL Gauge 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. Provide the minimum and maximum range values. Configure the gauge range using the “Add Range” button. For each gauge range, provide the start and end values, the section text, and the color code. Select colors from the drop-down list for the chart heading and body text. 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 SQL Gauge chart widget dashboard appears on the new page. 

In the example below, the Widget UI is configured as a “number” gauge type.  

The SQL gauge is rendered as a “number” type, as shown below. 

In the example below, the Widget UI is configured as a “label” gauge type using a SQL query that includes a date filter.  

The SQL gauge renders as shown below. 

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.