
Learn to build powerful reports in ServiceNow intermediate reporting using ETL tool, covering automated distribution, multi-data set reports, drilldown filters, chart colors, database views, and data source reports with variables.
Learn to automate report distribution with scheduled reports in ServiceNow, selecting the report, recipients, and Excel delivery. Schedule daily runs and on-demand execution while ensuring email is enabled.
Explore how to build a multiple data set report in ServiceNow, combining incident and problem data with time series visualizations and monthly aggregation for the last 12 months.
Learn how to drill down in ServiceNow reports by creating a dashboard, converting a list to a bar chart, and exploring active incidents and detailed ticket lists.
Enable open drilldown information in a new window or tab in the reports properties, saving the setting to preserve the dashboard focus while drilling down to the list view.
Create cascading filters in a ServiceNow dashboard using interactive filters. Start with assignment group, then assigned to, linked to the incident table, and reset filters for accurate results.
Map incident active values to consistent colors in bar charts by creating chart colors for true and false, green and gray, across reports.
Explore how to use report ranges to bucket incident reassignment counts, creating two data groups—less than one and greater than one—for bar visualizations.
Explore function fields in ServiceNow and how they compute data for reports and lists. Use substring and concat to derive priority digits and combine ticket number with description.
Build a database view in ServiceNow to join the problem and incident tables, enabling dot-walk relationships and cross-table data in reports.
This course is about creating reports and dashboards in ServiceNow. Each lesson was recorded using the ServiceNow Tokyo version and the development, steps, actions, and menu that you will see here are compatible with most of the previous and current versions.
The course includes a lesson to teach how to create your ServiceNow Account and Cloud Instance, so you don’t need to install any software to do this training, you just need Internet access.
This Course is part of a set of 3 courses:
ServiceNow Reporting - Level 1
ServiceNow Intermediate Reporting - Level 2
ServiceNow Advanced Reporting - Level 3
No prior experience in reporting tools or creating reports is required. But for Level 2 (this current course) we encourage you to take the ServiceNow Reporting Level 1, since that course covers important topics such as How to Setup your ServiceNow Developer Instance PDI, and in this one, we make the assumption that the Student know how to build Dashboards, Filters, use different types of Widgets, etc. which are covered in Level 1.
In this course, you will learn how to build reports and dashboards in the #1 ITIL tool, ServiceNow.
What you will learn:
•Automate report distribution - Scheduled reports
•Multiple dataset reports
•Drilling down within reports
•Set the on-click behavior
•Cascading Filters
•Chart Colors
•Report Ranges
•Function Fields
•Database View
•Data Sources
•Report with Variables fields
Reports best practice and more.