We are testing Discourse as a ticketing system and we are missing some metrics that (hopefully) we could enable with the Data Explorer 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.