Explore recipe: Reporting on Jira tickets

Return to top


  • Ioannis Nanos


    Is it possible to add a column in that report with the Jira's ticket number?



  • Gab Guinto
    Zendesk Customer Care
    Hi Ioannis,
    I'm afraid that Jira ticket ID is not an attribute natively available in Explore. If you create a custom ticket field and populate the field with the corresponding Jira ID, then you should be able to pull the data from that field to your Explore reports. 
  • Eva Kautenburger

    Hi there,

    is there any way we can separate Jira Ticket IDs in the Explore reporting? When more than one Jira Ticket is connected to a Zendesk ticket, the Ticket IDs are reported in one column and the displayed status reported of the Jira ticket is always the "highest" one, so it mostly says closed or done but you can't see which of the reported issues actually is done and if the other tickets have a different status. Any idea or workaround for this? 



  • Dane
    Zendesk Engineering
    Hi Eva,
    As what has been mentioned above, Jira Ticket ID is not a valid attribute in Explore. Therefore, we cannot return the values natively not unless you'll create a custom field for it and manually enter the values. This can later be used for your queries. 
    Thank you for understanding this current limitation.
  • Richard

    I have a custom field in tickets where we record the Jira Ticket ID. Is it possible to adapt this report (or create a new one) to show me how many Zendesk tickets I have linked to each Jira Ticket ID?

    We want this to help us quickly identify and prioritize the bugs our developers should be most focused on.

  • Erin O'Callaghan
    Zendesk Documentation Team

    Hi Richard, yes, as long as you're capturing the Jira ID in a custom field, this is possible! To create the report, add the metric from the recipe above, and then add your custom field as an attribute in the Rows column. This will give you a table with two columns: one for each Jira ticket ID, and one for the number of Zendesk tickets associated with that Jira ticket.

  • Sarath


    Is it possible to count tickets based on when the "jira_escalated" tag was added to create monthly/weekly reports?

    Thank you.


  • Elaine
    Zendesk Customer Care
    Hi Sarath,
    Reporting on "when" a specific tag was added/used in tickets is currently not possible in Explore. The closest date attribute that you can use in a report when a tag was used is by using the Update - Date attribute from the Support - Updates history dataset.
    I've taken a look at our Community and found that other users are discussing similar needs in the post titled Report on When Tag Was Added to Ticket. You can up-vote that original post and add your detailed use case to the conversation.
    Threads with a high level of engagement ultimately get flagged for product managers to review when they go through roadmap planning. I hope this helps! Stay safe!
  • Jay Krishnan


    Is it possible to report on the below -

    1. the time spent by the Ticket in the Group until the moment it was escalated as Jira.

    2. the time spent by the "Ticket" post escalation till the Jira is resolved i.e. the time from the moment Jira escalation happened to the time Jira is resolved.



Please sign in to leave a comment.

Powered by Zendesk