[Enhancement] SQL: Chats, total number of chats #644
Description
MODULE: Analytics
SCOPE: Chats
SQL: DSL/Resql/analytics/POST/chat-count-with-csa-and-chatbot.sql
Acceptance Criteria
- Total chats logic needs to be similar to [Enhancement] SQL: Overview total chats #622. All CSA chats are counted as CSA chats, everything else (pending, failed, system etc where no CSA is present) would be listed as a Bürokratt chat.
- 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).
- When hovering on the graph and either Bürokratt or CSA has 0 chats, the graph will still show the text with a value of 0 "Only Bürokratt involved: 0" or "CSA involved: 0".
- When "Additional options" is unchecked for "Only Bürokratt involved" or "CSA involved" then while hovering only the checked states will be shown (as-is).
- When total chats is 0 the hovering will not be displayed (remains as-is).
- Check that Overview and Chats have matching number for total chats. *
- Check that Overview and Chats tabs have matching number of chats for CSAs. *
- Check that Overview and Chats tabs have matching number of chats for Bürokratt. *
*- if no data is present, generate chats for today. Use "Selected period" to check Chat tab values against Overview chats if possible.