Types of Dashboard Widgets

Last published at: January 4th, 2023

FlowWright dashboard designer provides 2 kinds of dashboard widgets:

  • Preconfigured functional widgets - functionality is already built into the widget, only customization is the header text and colors
  • Customizable widgets - these widgets can be customized to bring data based on a SQL query or a configuration and render the data within the widget.  Also header text and colors can be also changed

Example of an Preconfigured widget

The above widget by default has the functionality to display the # of open tasks for the current user. The above widget only allows the following configuration:

 

Example of an Configurable widget

Custom bar chart widget allows the user to use a database connection and a SQL query to be configured to display a graph based the query result data.  The custom bar chart widget has the following configuration. Select the database connection from the dropdown list. Provide a SELECT SQL Query in the input field. Save the changes and preview the dashboard. 

Let's say we want the graph to display the top 5 users with most activity from FlowWright as a bar graph. 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 TOP 5 U.deExternalUserFullName as Name, COUNT(H.entryID) AS numOfHighestActivity 
FROM deItemHistory H INNER JOIN deUsers U ON U.deUserID=H.itemID 
GROUP BY H.itemID,U.deExternalUserFullName ORDER BY numOfHighestActivity DESC

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