Make the NULL value appear in queries...

3 Comments

  • Madison Davis
    Comment actions Permalink

    Hi Randy! Can you share your query and what you're hoping to measure? Including zero or null values might be specific to your use case. 

    0
  • Randy Nieukirk
    Comment actions Permalink

    Actually, I think my question has changed to, how do I make the "NULL" value appear as "No Response" in the x axis.  See how Yes and No appear in the bar graph below?  How dod I get NULL to appear?  Or how do I get NULL to appear as No Response?

    Metric:  Solved Tickets (Count)

    Columns:  Reoccurring Issue (from custom ticket form)

    values are:  Yes, No, NULL

    Filters:  Ticket Group (one group) and Ticket Solved Date (last week)

    0
  • Madison Davis
    Comment actions Permalink

    Thanks for clarifying, Randy! It sounds like what would actually help is a renamed set. You can read how to update the name of attributes in this recipe. It's talking about a different attribute, but can be applied to your custom field the same way!

    0

Please sign in to leave a comment.

Powered by Zendesk