Metrics and graphics under menu button Vestlused (chats)

[PaulaMerle]

AS AN Analytic module user I WANT TO have predefined chat-related metrics under Vestlused SO THAT I can visualize them easily by clicking on the desired metric.

Acceptance Criteria

General requirements

• [x] A separate sub-page for chat-specific analytics on GUI-side
• [x] Appropriate graph displayed according to selected metric and periods
• [x] When selected period is 1 day (today, yesterday or from calendar), the chart is displayed on hourly bases
• [x] #6 is taken into consideration
• [x] Chosen selection of metrics can be downloaded as CSV - https://github.com/buerokratt/Analytics-Module/issues/14

User selections for graphics to be shown

• [x] Three drop-down menus available as shown on prototype:
  1. -- vali mõõdik -- (choose metric), dropdown with only 1 possible selection
  2. -- lisavalikud -- (additional options) based on vali mõõdik / choose metric selection, checkboxes with multiple selection
  3. -- vali periood -- (choose period), dropdown with only 1 possible selection

Options in -- choose metric -- (dropdown with 1 possible selection)

• [x] Total number of chats (Vestluste koguarv)

  1. Only Bürokratt involved (Bürokrati vastatud)
  2. CSA involved (Nõustaja kaastatud)

• [x] Contact information provided (Kontakti jätmised)

  1. Outside working hours (Tööpäeva väline aeg)
  2. Long waiting time (Pikk ooteaeg) (Contact information is asked when queue number is 2 or bigger, specified: 12 Feb 2024)
  3. All CSAs away with red status (Kõik nõustajad ära / hõivatud)

• [x] Average waiting time (Keskmine ooteaja pikkus)

  1. The median (mediaan)
  2. Arithmetic average (aritmeetiline keskmine)

• [x] Average number of messages in a chat (Keskmine sõnumite arv vestluses)

• [x] Average duration of chats (Vestluse keskmine aeg)

• [x] Count of idle chats ended by Bürokratt (Bürokrati lõpetatud vestluste arv)

Options in -- vali periood -- (dropdown with 1 possible selection)

• [x] Today (Täna)
• [x] Yesterday (Eile)
• [x] Last 30 days (Viimased 30 päeva)
• [x] Selected months - from datepicker or any other possibility (Valitud kuud)
• [x] Selected period - from datepicker (Valitud periood kalendrist)

GUI

• [x] i18n used
• [ ] Side menu is generated based on an endpoint providing appropriate JSON
• [ ] Dropdown values as pre-defined configurable settings, no database used
• [ ] Choose from D3 library and https://canvasjs.com/react-charts/ to produce graphs
• [ ] Make REST requests to fetch appropriate data to produce graphs based on User's current selection

DSL

Ruuter

• [ ] REST endpoints to produce data for every metric

REST endpoints as CSV

• [ ] Handlebars DSLs or Javascript on Nodejs for chosen metrics provided in CSV instead of JSON, applies on all REST endpoints in the scope of this issue

[turnerrainer]

These predefined selections currently all have corresponding matches in a PostgreSQL database.

[mikkolli]

Figma wireframes can be found here: https://www.figma.com/file/Buf426ch4ToKq8dP47xJ75/B%C3%BCrokratt-Analytics-Design?node-id=0%3A1&t=D8SQVJNDtAdVZI9n-1

[PaulaMerle]

BUG - tested at https://admin.dev.buerokratt.ee/analytics/chats, 22.08.2023 Expected result: metric Total number of chats (Vestluste koguarv) should display the number of chats for the selected period (for both BYK and CSA conversations). Actual result: for selections 'today' and 'yesterday' the graphs are empty, although the chat history shows that there have been chats both with BYK only and with the advisor. Selecting the last 30 days, the graph displays yesterday's conversations, but only those that have taken place with BYK. The history shows that for 6 conversations, CSA has taken over the conversation. Today's chats are also not shown on the 30-day chart, although the history shows that there have been at least 11 (ended) chats.

Screenshot from chat history https://admin.dev.buerokratt.ee/chat/chat/history?page=2

Screenshots from analytics module:

• [x] TESTED 12.09 - DONE

[PaulaMerle]

BUG - Tested at https://admin.dev.buerokratt.ee/analytics/chats with screen size 2018 x 1003, zoom 100%. From time to time there are situations when the entire content of the page does not fit on the screen. The lower part of the graph remains off the screen. It is expected that the page follows responsive design and the user doesn't need to scroll the page to see the whole content.

• [x] TESTED 12.09 - LOOKS BETTER

[PaulaMerle]

BUG - Tested at https://admin.dev.buerokratt.ee/analytics/chats Expected result - the 'last 30 days' graph should display conversations for the last day as well (today). Actual result - On the last day of the graph, i.e. today, no chats have been displayed, although according to the database, 14chats have taken place on this date (today) at the time of testing.

TESTED 12.09 - done for metrics Total Chats and Average number of messages in a chat. Not sure about Contacts provided. Information for the last day is missing in Average time of Chats and Average waiting time (separate BUG comment is created for that).

[1AhmedYasser]

• https://github.com/buerokratt/Analytics-Module/issues/7#issuecomment-1688012532 Added A fix for showing today & yesterday chats

[1AhmedYasser]

• https://github.com/buerokratt/Analytics-Module/issues/7#issuecomment-1689369921

Enhanced Charts responsiveness, but it still depends on top metric options height as well, so in some cases it might still be pushed down if the top metric options has a lot of options available

[PaulaMerle]

BUG - tested 12.09 https://admin.dev.buerokratt.ee/analytics/chats For the Average time in Conversations metric, the data is not displayed in the Today and Yesterday time options. In the Last 30 days option, the last day's data is not displayed. If the selected month is an earlier month (August, July, etc.), the last day's data is also not shown. For example on 31.08 there were 5 chats, so average should be calculated.

• [x] TESTED and FIXED

[PaulaMerle]

BUG - tested 12.09 https://admin.dev.buerokratt.ee/analytics/chats For the Average Waiting Time metric, the data is not displayed in the period options Today and Yesterday. In the Last 30 days, the metric is calculated only for 3 days out of 30. Also only arithmetic average is calculated, median is always 0.

• [x] TESTED and FIXED

[1AhmedYasser]

@PaulaMerle We need to discuss the latest PR when your review it before the merge