All the SQL widgets share similar configuration UI features. After dragging a SQL 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 export data as CSV file, make a table responsive, and 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.
- Custom Bar Chart
- Custom Line Chart
- Custom Number Chart
- Custom Pie Chart
- SQL Donut Chart
- SQL Stacked Column/Bar Chart
- SQL Scatter Plot Chart
- SQL Funnel Chart
- SQL Stacked Area Chart