Skip to content

[Enhancement] SQL: Chats, Count of idle chats ended by Bürokratt #649

@JaanikaTalvistu

Description

@JaanikaTalvistu

MODULE: Analytics
SCOPE: Chats
SQL: DSL/Resql/analytics/POST/chat-count-only-chatbot.sql

Acceptance Criteria

Logic must be similar to the overview tab SQL (DSL/Resql/overview-total-chats-no-csa.sq), linked to #623

  • SQL calls out created chats between specified time (as-is).
  • Counted chats need to have an ENDED status (as-is).
  • Only unique chats are counted (as-is).
  • Only exclude all advisors from the SQL. Has to match the overview logic, please remove 'taken-over' event.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    Status

    Ready

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions