Displaying 0 value in ServiceNow reports

Omer3 · ‎02-19-2020

Hi community,

Is there a way display the 0 value within a ServiceNow time series report? At the moment if there is no value ServiceNow will exclude that data.

Thank you in advance.

Slawek_Radziewi · ‎02-20-2020

Unfortunately reports are showing existing data thus you can see created or closed these days. If there was nothing recorded it won't show up on report view.

For that purpose there is PA actually. There you collect data every day so when there was no data it will save 0. After that you can display data on dashboard and see when there were records and when there was 0 during a day, month, etc.

As I was saying we need table with data to be displayed weather it is PA or new table created for that purpose it doesn't matter. You can try to create table and collect there daily statistics from where you can report such general data and get values like 0.

View solution in original post

mcconnellsj · ‎04-27-2021

Here is a neat workaround

https://community.servicenow.com/community?id=community_question&sys_id=21dce8d3dbc65f04fc5b7a9e0f961926