Question
When building a report I noticed some data is missing. How can I include 0 values in Explore reports?
Answer
There are a few ways to include 0 values in reports. The most popular are listed below. Use the one that suits your report configuration.
Time-based reports
If a report is time-based and there is no data displayed for NULL values of time attribute dimensions, like dates, weeks, or months, you can use the Time axis result manipulation.
To enable the Time axis
- In report builder, click Result Manipulation (
). - Select Time axis from the list.
- Click Use Time axis checkbox; and then click Apply.
Reports with attributes on columns and rows
When a report has attributes on both columns and rows it sometimes has null values. This is especially visible in tables because some of the cells are empty. Use the Result metric calculation to replace these empty cells with 0 values.
For example, your report looks at the number of tickets created by year and group. It has Tickets in metrics, Ticket created - Year in columns, Ticket group in rows, and some cells are empty.
To create the result metric calculation
- In report builder, click Result Manipulation ().
- Select Result metric calculation from the list, then click Add a new metric.
- Enter a name for your result metric calculation.
- In the Formula box, from the Insert menu select the metric you need. In this example, it is COUNT(Tickets), then add "+0" to the formula. Your final formula will be:
COUNT(Tickets)+0
- When you are finished, click Clear used metric checkbox and then +Add.
28 comments
Eldar Samoilov
Hi, my report has attributes, the “+o” method doesn't work… Any other ways?
0
Federico Costa
+1 no funciona la manipulación de los resultados poniendo el "+0"
0
Rebecca
+1, we cannot include articles that got 0 views using the Guide: Knowledge Base dataset on our monthly metrics review, since Explore/Analytics only returns articles that had 1 view or more no matter which way I try to filter or report on it. Is this intended behavior or “missing” or “null” data with a workaround? None of the above old tips seem to help.
0
Adrian SVANDRA
Hello,
I do not see any update or reply regarding the necessity of having “Null” results still appearing in Reports. It's very important to have these data appearing for me as well. Any news or workaround?
1
Jakob Kruse
Is this feature available in some hidden form in 2024? I want to display the age (in days) of our unsolved tickets as a bar chart, but it is very misleading when the x-axis does not have an equal unit of 1 day. I really need to display the NULL values as bars of height 0.
1
Noelle Cheng
Is there any update on this??? I really need to see my NULL value options on my reports. We need to be able to look at all data whether they have "used" or not.
4
Dave Dyson
0
Gustavo Parra
Yoram Dagan, how did you color-code your columns?
1
Ease
Hey CJ Johnson, so what you have is actually the exact report I started with.
If I do published articles as first metric and views as second, it excludes articles with 0 views. This is what got me down the rabbit hole because it doesn't really make sense to me that it would exclude 0 views with this setup.
If I remove the views metric and keep just published they all show up. I was using an article title filter against an article with 0 views as a second way to see if it was showing up after adjusting the metrics.
1
CJ Johnson
Ben Rosenberg
You might have success by adding in the "Published Articles" count. This would return a 1 for each article, even if the view count was zero. You could then hide that column even from the report, to keep it from being cluttered. I wasn't able to fully test this because I couldn't find a 0 view article (our own checks to make sure it looks good clearly get picked up), but I think it should do the trick. You can use Article Title if you prefer, it should work just as well as Article ID.
0
Sign in to leave a comment.