Explore recipe: Count of tickets for a custom ticket field value

Return to top
Have more questions? Submit a request


  • JDeL

    Is there a way to use a calculated metric or something else to get a count of custom fields based on value?

    For instance, I have a field called 'version' that works just fine (v1, v1.1, v1.2, v2... etc).  What I'd like to be able to do is get a total count of the tickets for all of version 1 (v1all) including the dot releases and show that value on the report along with the number of tickets for each dot release.

    This doesn't work, but something like sum([version]="v1*")

    Can this be accomplished?  I'm fine if I have to list them separately and just use a + but that doesn't seem to work either.  

  • McCabe Tonna
    Community Moderator

    Can you screenshot what you currently have?

    In your query - you go to Result Manipulation

    Totals: Grand totals on Col/Row - Aggregator: Sum

  • Hillary Latham
    Community Moderator

    JDeL, if your field is a list of values/choices, you could make a custom attribute group to pull together all the "dotted" values under the larger header.  https://support.zendesk.com/hc/en-us/articles/360022184334-Organizing-values-by-groups-and-sets.

    Or you could build a custom attribute. I have a free text field for version in my Zendesk, so I wrote a custom metric for all the combinations of shorthand people use to document the version.  From what you wrote, you could do something similar: LEFTPART([version],2).  This would just take the left two characters so all your "dots" roll up.  Then use results manipulation on that custom attribute.



Please sign in to leave a comment.

Powered by Zendesk