Report "Trend" - How to show empty values/data?

Marissa
Giga Contributor

HI, I've seen this question posted a few times but none seem to have gotten an answer because the OP never got back to their question.

I have created a report based on the type Trend, where the x-axis are months. It shows amount of high priority tickets made per month, but when there are no such tickets made in a month, then the month doesn't show up in the chart. For an overview that is not to be misunderstood accidentally, i would like to show these empty months in the chart. How do I go about that, using these settings?

I've blocked out any sensitive information, so I hope the screenshots are still clear enough. I've added the source, filters and the chart to show what's missing. Thanks in advance!

 

 

12 REPLIES 12

Adam Stout
ServiceNow Employee
ServiceNow Employee

What version are you running?  Do you see any options in the report designer instead of the legacy report builder?

Marissa
Giga Contributor

Hi Adam!

We're on Istanbul. I don't have an option for a report designer that I can see; where can I find this?

Marissa
Giga Contributor

Hi all, anyone that could look into this?

Sushil Chaudhar
Kilo Guru

Hi,

You can try using performance analytics time series widget for incident, it displays empty values.

find_real_file.png

find_real_file.png

--

Sushil.