How to open a UI page in a Widget to be added to a dashboard
Sometimes there are highly customized requirements that request the return of values/variables not part of a table, and as a result, we cannot use them in a report with the OOTB functionalities provided by ServiceNow.
In the example I will demonstrate, I need a report with the sum of the sponsoring fees per year. These values are obtained through a script include and do not belong to any variable in the “Sponsoring” table.
Visualization of the sponsoring fee per year in two records, calculated based on three variables from the table (start, end, and fee). The table was generated through a UI macro added to a formatter.
Problem: How can I use the data generated for all records to create a report with the sum of the sponsoring fees per year?
Solution: Create a UI page to generate the table with the results of the sum of the sponsoring fees per year, and add it to a widget to be displayed on a dashboard.
Result:
Development:
UI Page
Objective: create a list/table with the records of the sum of all fees per year.
Note: Other ways to visualize the data can be created, for example, through charts.
Widget
Objective: add the UI Page to a widget to be used in a dashboard.
Dashboard
Now the widget is available and can be added to a dashboard:
