Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to exclude 0 values in SLA reports?

Michael Austin February 16, 2022

Hello,

I'm quite new so please bare with me. I'm developing a dashboard for a service project that handles support tickets and requests. One of the reports that I'm creating for this dashboard is SLA First Response - Met. 

There are some days that we do not receive support tickets which causes a 0 value for those days. This makes the line graph look rather clunky towards the bottom which leads me to my question:

Is there a way to exclude the 0 value, but still include the days? This would look like a line on the x axis instead of multiple circles. The circles I'm mentioning are detailed below:

ZeroValue_ToBeRemoved.png

I tried including != 0, != null, != EMPTY, and != IS EMPTY in JQL but that didn't produce the result I was looking for.

1 answer

1 vote
Michael Austin February 16, 2022

 .

Suggest an answer

Log in or Sign up to answer