[Paid] Data explorer queries for ticketing system use case

(Quim Gil) #1

Part of [Paid] Meta-request for ticketing system related improvements.

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.

(Quim Gil) #2

Maybe any of these queries (or something pretty close) has been addressed in What cool data explorer queries have you come up with? or similar topics. I confess I haven’t scanned systematically.

(Quim Gil) #3

Just FYI, this request is being funded. We plan to work on it in the upcoming weeks.