Displaying 0 value in ServiceNow reports

Omer3
Giga Contributor

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.

1 ACCEPTED SOLUTION

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

5 REPLIES 5

Slawek_Radziewi
Kilo Sage

Could you show example? 

In reports you should see 0 values.

In Performance Analytics you define in indicator to show 0 when value is nil.

Hi Slawek,

I am not using Performance Analytics. The only Performance Analytics that is available is the complimentary one. I am currently using the out of the box reporting. Please see below as an example:

 

find_real_file.pngfind_real_file.pngAs you can see Thursday and Friday will have 0 values which are excluded from this report. There are no options that I can see to display the 0 value. 

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.

Thanks for your reply Slawek, this explains why I cannot get the value 0 to display. I will mark this as the correct answer.