ServiceNow – Handy Report/Dashboard Features.

Date/Time ‘Relative’ Conditions

Sometimes it is handy to display records based on Date/Time values. As an example, you might want to know the number of contracts in the contracts module that will expire within 7 days in your Dashboard?

  1. Create a table Contract [ast_contract] report with ‘Single Score‘ as report type. Let’s call the report: ‘Support/Warranty Expires Within 0-7 Days:‘.
  2. Add the ‘relative‘ conditions below:

Some other condition exaples:

3. You can now use this report result as a ‘widget’ in your Dashboard:

Interactive Filter

Instead of having loads of different reports with fixed conditions you can create one report and link this to a interactive filter picker. This will save space in your Dashboard as well as give the dashboard user additional flexibility to quickly manipulate the report output.

  1. Let’s start with creating a standard ‘List’ incident report that we later can create a ‘dynamic filter’ for. Let’s call it ‘Service Desk Ticket Count‘:

2. Now lets create the ‘Interactive Filter’. Let’s call this one ‘Incident State – Checkboxes‘.

3. Now lets create a Dashboard (assume you know how to do this) add both report [Add Widgets -> Reports -> Service Desk Ticket Count] and interactive [Add Widgets -> Interactive Filter -> Choice List -> Incident State – Checkboxes] filter to Dashboard and link them together.

Below show report and Interactive Filter added to dashboard:

Now link the report to the Interactive Filter:

Now you can see the result, when you change the Interactive Filter the report will dynamically update against input:

Leave a Reply