How to Make a Time Series Report Without Gaps?

laurenmcmanamon
ServiceNow Employee
ServiceNow Employee

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! 🫶🏻 

2 REPLIES 2

Manmohan K
Tera Sage

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]

Manmohan K
Tera Sage