How can I include 0 values in reports?

Return to top

12 Comments

  • Tina Yates

    Have you heard back Vladimir Petrushenka .  I have the same issue where the last attribute in my report doesn't show up (year ticket created), so far this year it would be zero but it isn't showing 2021....0 my report is stopping at 2020. Thanks

     

    0
  • Yoram Dagan

    HI

    I have tried to create a new metric COUNT(Tickets)+0 and add it to the Metric of the query instead of having it in the "result metric calculation". and it didn't work

    I have done so as I also wanted to use advanced formatting and by Zendesk support, advanced formatting will not work in you clear the used results.

    Any Ideas?

     

    Thanks

    Yoram  

    0
  • Vladimir Petrushenko

    hi @... 

    no, no one's responded. @... could you please advise us on this one when you have a minute? Or should we raise a support ticket ? 

    Many thanks, 

    Vladimir

    0
  • Elle

    Is the Time Axis feature not available for calculated attributes? I created a new "Ticket Created - Hour Ordered" attribute so I could rename the values (e.g. 0 > 12am, 1 > 1am, etc.) and reorder them. However, when I swap the standard "Ticket Created - Hour" attribute out for my new one, the Time Axis feature is no longer available under Results Manipulation. Thanks!

    0
  • Eugene Orman
    Zendesk Product Manager

    @..., @... I don't think there is a way to show the last data point if it has no data available. We will see how to improve this functionality when we will be working on this part of the Query building experience. 

    @... You need to use the Result metric calculation, not the Standard calculated metric. Result calculations are done after the data is pulled from the database that's why it allows showing some of the values as zeros. 

    @..., Yes the Time Axis feature is only available for the default time attributes. 


    0
  • Terence Kennedy

    Is there a way to show all values for all hours?

    I have tried this approach, as well as the time axis "fix", but it still does not show any values for hours that have 0 tickets created at the start of the day (i.e. it would show empty values in-between hours that have tickets, but only starting at the first ticket of the day). For example:

    First ticket comes in at 6AM, then no tickets until 9AM, hours 7 and 8 are still shown, however, hours 0, 1, 2, 3, 4, and 5 are not shown.

    I just want every hour from 0-23 to show to keep comparisons between subgroups or other classifications easy to make, rather than having to work harder to establish which is the 5th hours of the day in 4 different graphs.

    Thanks!

    0
  • DJ Buenavista Jr.

    Hi,

    Thank you for reaching out to Zendesk Support.

    In regards to your concern, this article mentioned that the Time axis result manipulation is only visible if you are using a time-based attribute and when you add it to the Columns panel. The Time axis feature works only with a date field and will not work with 'Days of Week'.

    Thank you!

    Regards,

    DJ Buenavista Jr. |
    Customer Advocacy Specialist |

    0
  • Dolphin 3

    With table format, is there a way to get empty rows (having all 0s) to display?

    I was able to get the cells having 0 to display using COUNT(tickets)+0 method above but it only works when some other cells of same row have a value

    Otherwise if all cells of a row having 0, then that row does not display.

    (e.g. an agent does not have any ticket in any status on the report)

    Thanks in advanced

     

    0
  • Cheeny Aban
    Zendesk Customer Care

    Hi Ryan,

    Unfortunately, there is no native way to do that in Explore yet. Columns with NULL values in your query will not show by default. If an entire column is full of NULLs, it will always be hidden. Explore handles NULL values and zeros (0) differently.

     

    0
  • Dolphin 3

    Thanks Cheeny. Yeah I was wondering if there is away to show row having all NULL values. (At the top of this article it mentions as what you said and point to another question. And then on that question it points back to here)

    Our goal is to show out ticket status count per agent daily (columns = ticket statuses, rows = agent list). And we want to show full list of agents, even if each agent has 0 for all ticket statuses on that day, to make it consistent for the system to process the CSV report file from Explore.

    It's pretty inconvenient that Explore does not have this option available. Is there a way to add it to Explore in the future? It's common scenario, a few people would like to have it.

    0
  • Cheeny Aban
    Zendesk Customer Care

    Hi Ryan,

    We understand your need for this functionality so I am marking this ticket as Product Feedback. We truly value customer feedback and your voice and votes in the product feedback topics in the community help influence future Zendesk functionality.

     

    0
  • Liudmila Rybakova

    @... Hi Cheeny! I join the request to have a possibility to show the row in the report despite it does not have any data in it. I can always hide not needed rows, so, no need for the system to do it without asking me :) 

    0

Please sign in to leave a comment.

Powered by Zendesk