How can I include 0 values in Explore reports?

Have more questions? Submit a request

6 Comments

  • Samuel Finlay
    Comment actions Permalink

    Hi!

     

    I am curious if you could further elaborate on what (0) value would mean?

     

    Looking through ALL of the documents on Explore before I continue to build and this looks like something worth understanding. 

     

    Appreciate your reply!

     

    Best,

    Samuel D Finlay

    0
  • Eugene Orman
    Comment actions Permalink

    @Samuel, zero values in this context will be time points (hours, dates, month, etc) that had no data associated with them. I have added a GIF demo to the article. In this example, there were no tickets created in May and July. To show these months the Time axis feature was used.

    0
  • Hannah Voice
    Comment actions Permalink

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

    0
  • Chris Bulin
    Comment actions Permalink

    We have a table that has blank values for ticket count. Since this isn't a time value, is there a way to display 0 rather than blank? Weirdly, it has a 0 for Q2, but not Q1. 

    0
  • Brett - Community Manager
    Comment actions Permalink

    Hey Chris,

    It's odd that this isn't showing a 0 value for Q1 but shows correctly for Q2. I'm going to bring this into a ticket so our Customer Advocacy team can look into this further.

    You'll receive an email shortly stating your ticket has been created.

    Cheers!

    0
  • Chris Bulin
    Comment actions Permalink

    Thanks Brett - Community Manager!

    0

Please sign in to leave a comment.

Powered by Zendesk