- 22 Nov 2023
- 2 minute read
- Print
- DarkLight
- PDF
Report Widgets for Student Success
- Updated 22 Nov 2023
- 2 minute read
- Print
- DarkLight
- PDF
Widgets are snapshots of Slate data that can be displayed on the Slate Homepage or the Reader. Widgets are designed to provide a quick overview that does not necessarily have to be built out into a full-blown query or report.
A strong understanding of the Query Builder is recommended, as widgets are simply a visual representation of query exports and filters.
Create a New Widget
Click Queries / Reports in the top navigation bar.
Click New Widget.
Give your widget a name and click Save.
Tip
Naming a widget Homepage or Reader will make the widget charts appear immediately on the Slate Homepage or Reader. For Homepage widgets, create multiple tabs of widgets using the following nomenclature: Homepage - Tab Name.
By default, widgets are shown to all users, but they can be shared with specific users, roles, or permissions as needed.
Example of a Homepage with multiple widget tabs and multiple charts on a widget.
Configure a New Widget
Widgets are comprised of one or more charts. Each chart aggregates data based on a particular query base. It is not only acceptable, but often desired, to have multiple charts in a single widget each reflecting data from a different query base.
Add a New Chart
From the Add Chart drop-down menu, select the appropriate query population. It is also possible to add a static HTML area by selecting 'Custom SQL / HTML.'
In the Edit Chart window, provide a Title for your chart.
Select the desired chart type. The different chart type options are:
Data Table
Pie Chart
Bar Graph
Horizontal Bar Graph
Line Graph
Additional options to configure the chart will display depending on the chart type (see the following section for detailed instructions for each option). Complete these options to display the desired data.
Add any filters to identify the specific population on which you want to report.
Click Save.
Add additional charts as desired, repeating steps 1-6.
Set Sharing Permissions for Widgets
Click Share, then click Add Grantee.
Set to Active.
For Type, select whether the widget should be shared to a specific User, or based on Permission, or on Role.
Enter the user, or select the role or permission to be granted access to the widget.
Check 'Display Widgets' to give view access to the widget. Select 'Edit Widgets' to grant view plus edit access to the widget. Click Save.
Additional Chart Settings
Data Table, Bar Chart or Horizontal Bar Chart Configuration | |
---|---|
Category | Select an export to categorize data. |
Series (optional) | If additional granularity is desired, select an export for the series as well. |
Includes Series Total | Include a total row for the series. |
Value Type | Select how the data should be aggregated: Count, Average, Minimum, Maximum. |
Pie Chart Configuration | |
---|---|
Slice By | Select an export to split the pie chart data. |
Line Chart Configuration | |
---|---|
Interval | Select the appropriate time interval for the X-axis: Day, Day (Cumulative), Month, Month (Cumulative), Fiscal Day of Year, or Fiscal Day of Year (Cumulative). The cumulative options provide a "running total" while the non-cumulative options simply report the number that occurred at that particular time. |
Date Field | Choose the export that indicates the time (e.g., Prospect Created or Application Submitted). |
Series (optional) | If multiple lines should be displayed, select the export that creates those lines (e.g., Round Key). |
Include Series Total | Toggle on the total count for the series as desired. |