# \[مدفوع\] استعلامات مستكشف البيانات لحالة استخدام نظام التذاكر
**URL:** https://meta.discourse.org/t/paid-data-explorer-queries-for-ticketing-system-use-case/109402
**Category:** Marketplace
**Created:** [17 فبراير 2019، 10:38م 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:** 6
**Page:** 1
### Author:  [@icaria36](https://meta.discourse.org/u/icaria36)
#### Post date: [17 فبراير 2019، 10:38م UTC](https://meta.discourse.org/t/paid-data-explorer-queries-for-ticketing-system-use-case/109402/1 "2019-02-17T22:38:24Z")
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.
---
### Author:  [@icaria36](https://meta.discourse.org/u/icaria36)
#### Post date: [17 فبراير 2019، 11:03م UTC](https://meta.discourse.org/t/paid-data-explorer-queries-for-ticketing-system-use-case/109402/2 "2019-02-17T23:03:44Z")
Maybe any of these queries (or something pretty close) has been addressed in [(Superseded) What cool data explorer queries have you come up with?](https://meta.discourse.org/t/what-cool-data-explorer-queries-have-you-come-up-with/43516) or similar topics. I confess I haven’t scanned systematically.
---
### Author:  [@icaria36](https://meta.discourse.org/u/icaria36)
#### Post date: [24 فبراير 2019، 7:28ص UTC](https://meta.discourse.org/t/paid-data-explorer-queries-for-ticketing-system-use-case/109402/3 "2019-02-24T07:28:02Z")
Just FYI, this request is being funded. We plan to work on it in the upcoming weeks.
---
### Author:  [@icaria36](https://meta.discourse.org/u/icaria36)
#### Post date: [21 مارس 2019، 7:52ص UTC](https://meta.discourse.org/t/paid-data-explorer-queries-for-ticketing-system-use-case/109402/4 "2019-03-21T07:52:12Z")
Just a note to say that this [Paid] task has been commissioned and the work will start in April.
---
### Author:  [@icaria36](https://meta.discourse.org/u/icaria36)
#### Post date: [12 أبريل 2019، 8:33ص UTC](https://meta.discourse.org/t/paid-data-explorer-queries-for-ticketing-system-use-case/109402/5 "2019-04-12T08:33:32Z")
تم نشر الاستفسارات الأولى في [Time to first response for a support group](https://meta.discourse.org/t/time-to-first-response-for-a-support-group/275154?u=quimgil)
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [12 مايو 2019، 8:38ص UTC](https://meta.discourse.org/t/paid-data-explorer-queries-for-ticketing-system-use-case/109402/6 "2019-05-12T08:38:07Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.