Make the NULL value appear in queries...

3 Comentários

  • Madison Davis
    Ações de comentário 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
    Ações de comentário 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
    Ações de comentário 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

Por favor, entrar para comentar.

Powered by Zendesk