[Enhancement] Analytics: new metric under Chats "Follow-up Status overview"

[JaanikaTalvistu]

MODULE: Analytics
CATEGORY: Chats
RELATED TO: Quality measurement

NEW QUERY: Follow-up Status / Järeltegevuste staatuste ülevaade

SQL metric criterias

• Filter chats where a "Follow-up Status" selection is made.
• Group by Follow-up Status counter
• Additional options have each mentioned Follow-up Status as a checkbox option.
• Additional options has a "Select all" checkbox.

Apply general SQL logic for the metric:

• SQL calls out created chats between specified time. Including the time marked on the datetime field (1st of Januarty includes data starting from 1st).
• Counted chats need to have an ENDED status.
• Only unique chats are counted.
• 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.
• Chats marked as TEST are excluded.

Graph general criterias:

• Graph does not show empty values such as "-" or such. Note! The number 0 is not an empty value in most cases unless specified!
• Graph counters scale as the values grow. Scale is rounded up to the tenth number (In case of 1 then 10 is shown, 49 shows 50, 132 shows 140 etc)
• If no data is present, the time period on the graph is still displayed as selected.
• The graph displays the start date on the left side of the graph.
• The graph displays the end date on the right side of the graph.

[reinik2]

AT passed