# \[Paid\] Data explorer queries for ticketing system use case

**URL:** <https://meta.discourse.org/t/paid-data-explorer-queries-for-ticketing-system-use-case/109402>\
**Category:** Marketplace\
**Created:** [February 17, 2019, 10:38pm UTC](https://meta.discourse.org/t/paid-data-explorer-queries-for-ticketing-system-use-case/109402 "2019-02-17T22:38:23Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![icaria36](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/icaria36/32/426431_2.png) [@icaria36](https://meta.discourse.org/u/icaria36)\
**Post date:** [February 17, 2019, 10:38pm UTC](https://meta.discourse.org/t/paid-data-explorer-queries-for-ticketing-system-use-case/109402/1 "2019-02-17T22:38:24Z")

</div>

Part of [[Paid] Meta-request for ticketing system related improvements](https://meta.discourse.org/t/paid-meta-request-for-ticketing-system-related-improvements/109401).

We are testing Discourse as a ticketing system and we are missing some metrics that (hopefully) we could enable with the [Data Explorer](https://meta.discourse.org/t/data-explorer-plugin/32566) plugin and related queries. We are looking for someone experienced in SQL to write these queries.

We create quarterly reports with these metrics, which we use as performance indicators.

- Time to first response for a given group, counted in business days (Monday to Friday + a set of annual holidays that could be introduced manually once a year).
- Number of messages received in a given group.
- Given a set of tags, number of messages and percentage of the total of messages with each tag in a given group.
- Number of messages automatically filtered as spam for a given group.

---

_[View the full topic](https://meta.discourse.org/t/paid-data-explorer-queries-for-ticketing-system-use-case/109402)._
