Configuring a Custom Number Widget

Last published at: May 14th, 2024

The custom number widget is able to bring data using a database connection and a SQL query and display a numerical value based on the resulting data.

Once you drag a the custom number widget to the dashboard designer canvas, hover over the widget and click the edit icon.  Edit icon should display the following configuration screen for the widget:

Let's say we want the graph the total number of users from FlowWright as a number widget. Then select an existing connection to the FlowWright database, or if a connection doesn't exist, create one and select it.

Enter the following SQL statement for the SQL query input field:

SELECT count(1) from deUsers

Click the "Save" button to save the configuration.  Click the preview icon on the widget to preview the number widget.  Preview should display the following: