Backlog vs solved tickets trendline | Community
Skip to main content

Backlog vs solved tickets trendline

  • August 23, 2019
  • 1 reply
  • 0 views

With reference to this article:
https://support.zendesk.com/hc/en-us/articles/203661116-Understanding-backlog-evolution

Is there an explore recipe to build a query for a trendline to show backlog vs solved tickets over time?

This topic has been closed for replies.

1 reply

Hannah27
  • August 27, 2019

Hello Simone,

This isn't a report that is possible to create in Explore, since the backlog dataset does not include data on solved tickets. The best solution I can come up with would be to create two separate queries and put them on the same dashboard.

The first query would use the Backlog History dataset, with tickets as your metric, and Backlog recorded - Date on columns.

The second would use the Ticket Updates dataset, with Tickets Solved and Tickets created as your metrics and Update - Date on columns.