Dashboard Data Sources

[kack l]

Hi Community,

I have a requirement to display data on a dashboard using Data Visualization → Single Score, where the records will change to the "Registered" status within the next 3 days.

The calculation logic is:

• In the table, records with the status "Completed" or "Modified Completed" will automatically change to "Registered" 14 days after they reached those statuses.

• Therefore, I need to find records that will automatically become "Registered" within the next 3 days, and display them in the dashboard's Single Score component.

What is the best way to implement this in ServiceNow?

Thanks in advance!

[G Ponsekar]

Hi @kack l ,

You can achieve using reports

• Create a Report:

  • Navigate to Reports > View / Run.
  • Click Create a Report.
  • Data:
    • Table: Select the table containing the records (e.g., incident, task, or a custom table).
    • Type: Select Single Score.
  • Filter: Apply the following conditions to identify records that will become "Registered" within the next 3 days:
    • Status is one of Completed, Modified Completed.
    • Date of Status Change (or the relevant date field capturing when the status became "Completed" or "Modified Completed") is on or before javascript:gs.daysAgo(-11) (This calculates 14 - 3 = 11 days ago, meaning records that achieved the "Completed" or "Modified Completed" status 11 days ago or earlier will transition to "Registered" within the next 3 days).
    • Date of Status Change is on or after javascript:gs.daysAgo(-14) (This ensures the records are within the 14-day window for transition).
  • Style: Configure the display options for the Single Score report as desired.
  • Save: Save the report with a descriptive name.
• Add to Dashboard:

  • Navigate to the desired dashboard.
  • Click Add Widgets.
  • Select Report.
  • Search for and select the report created in the previous step.
  • Add the report to the dashboard.

This setup will create a Single Score widget on the dashboard that dynamically displays the count of records that are projected to automatically change to "Registered" status within the next 3 days based on the defined 14-day rule.

If I could help you with your Query then, please hit the Thumb Icon and mark as Correct !!

Thanks, GP

[kack l]

Thank you for your response! This is just one of my requirements. I also need to calculate:

1. Records that will become "Registered" within the next 1 day.

2. The average number of "Registered" records per day for the current year.

Can both of these calculations also be achieved using the same method you suggested?

[G Ponsekar]

Hi @kack l ,

Yes you can reproduce in same way. 

If I could help you with your Query then, please hit the Thumb Icon and mark as Correct !!

Thanks, GP

[kack l]

Thank you very much for your answer.