All the SQL widgets share similar configuration UI features. After dragging a standard widget onto the dashboard designer canvas, click the Edit icon to set its properties.
Our UI gives you complete control over your dashboard's look and feel. Provide the title text that best suits your needs. Select the DB connection from the drop-down list. Provide the SQL Select syntax using the $dateFilter (wildcard) to sort the result set on the date column. Use the “Test Query” button to validate the SQL syntax. A success notification is displayed in the top-right corner. Use the checkbox to format dates. Click on the Save button to confirm the changes.
The process for setting up custom dashboard SQL Widgets is consistent. If you'd like to learn more, please click on the link provided.