How to Make a Time Series Report Without Gaps?

laurenmcmanamon
ServiceNow Employee
ServiceNow Employee

‎05-22-2023 08:20 AM

Hey y'all! It's been a while since I dipped my toe into reporting and need some help. Is there a way to create a time series report that doesn't show these gaps when there was nothing logged for that date? 

 

Right now, the report below is doing a sum of the Count field and trending by Created on. Obviously, I could do an average of Count for the week, but wondered if I was missing something. Thanks in advance! 🫶🏻 

Preview file
229 KB
0 Helpfuls
  • 945 Views
2 REPLIES 2

Manmohan K
Tera Sage

‎05-23-2023 01:05 AM

Hi @laurenmcmanamon ,

 

I am assuming that you are creating the report using performance analytics.

You can use the Time Series charts in Reports module to do reporting as well. OOB, it will not show the day/month/quarter/year on the visualized data if there is no data on these day/month/quarter [depending on how it is trended]

0 Helpfuls

Manmohan K
Tera Sage

‎05-23-2023 01:10 AM

@laurenmcmanamon ,

 

Refer below article for details 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0864103

0 Helpfuls