Skip to content

[Enhancement] SQL: Chats, Average waiting time (min) #647

@JaanikaTalvistu

Description

@JaanikaTalvistu

MODULE: Analytics
SCOPE: Chat
SQL:

  • DSL/Resql/analytics/POST/chat-avg-waiting-time.sql
  • DSL/Resql/analytics/POST/chat-median-waiting-time.sql

Acceptance Criteria

  • Counted chats need to have an ENDED status (as-is).
  • Only unique chats are taken into account (as-is).
  • Calculation is from the last Bürokratt message until a CSA picks up the chat (as-is).
  • Average and median is used (as-is).
  • Test chats are excluded (as-is).

Metadata

Metadata

Labels

Type

No type

Projects

Status

Done

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions