The SQL Table Grouping Widget lets dashboard designers present SQL-based tabular data in a grouped format, helping users organize and analyze related records in a FlowWright dashboard.

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 Label 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. Choose the database connection from the drop-down list. Provide the correct SQL SELECT syntax for the SQL Grouping chart algorithm. Use the $dateFilter (wildcard syntax) in the WHERE clause and reference an appropriate date column. Click the “Test Query” button to validate the SQL SELECT syntax. Click the plus sign (+) to insert Grouping Columns. Click the plus sign (+) to insert Aggregation Columns. Use the arrow keys to rearrange the column order. Select the checkbox to make the table responsive and format date columns. 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 SQL Grouping widget dashboard appears on the new page. 

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.