search

buerokratt / Analytics-Module

0 stars 14 forks source link

Metrics and charts under menu button Tagasiside (feedback) #9

Open PaulaMerle opened 2 years ago

PaulaMerle commented 2 years ago

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

Acceptance Criteria

NPS as Net Promoter Score https://npscalculator.com/en

General requirements

User selections for graphics to be shown

See https://github.com/buerokratt/Analytics-Module/issues/33 for endpoints

  1. customer received response (byk status) (Bürokratt - klient lahkus vastusega)
  2. customer did not receive response (byk status) (Bürokratt - klient lahkus vastuseta)
  3. unspecified reasons when Bürokratt closes idle sessions (Bürokratt - klient lahkus määramata põhjustel)
  4. accepted response - CSA involved (Nõustaja - aktsepteeritud vastusega)
  5. hate speach - CSA involved (Nõustaja - vihakõne tunnused)
  6. answered to the contact left by the customer - CSA involved (Nõustaja - vastatud teises kanalis)
  7. other reasons - CSA involved (Nõustaja - muud põhjused)
    • [x] options in -- lisavalikud -- for feedback to selected CSA: dropdown with the list of CSA names
    • [x] options in -- vali periood --:
  8. today (Täna)
  9. yesterday (Eile)
  10. last 30 days (Viimased 30 päeva)
  11. selected months - from datepicker or any other possibility (Valitud kuud)
  12. selected period - from datepicker (Valitud periood kalendrist)

image

GUI

DSL

Ruuter

REST endpoints as CSV

Bug reports

All ACs that have not been ticked, are considered as bugs

turnerrainer commented 2 years ago

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

PaulaMerle commented 2 years ago

FYI Added one more selection - Feedback to selected CSA

1AhmedYasser commented 1 year ago

The First Metric (statuses for closed chats / total chats (Lõpetamise staatused / vestluste arv) & its options cant be derived out from the Postgress database at the moment. As discussed by Varmo, we need to connect the Rassa database in order to pull out the required metrics for the first one. @turnerrainer

On a note here, i found that the current postgres database has the following events in the message table:-

  1. Answered
  2. Terminated
  3. greeting
  4. client-left
  5. requested-authentication
  6. contact-information-fulfilled
  7. ask-permission-accepted
  8. rating

Here is the first metric i mentioned and the options i need to derive from Rassa Database

  1. statuses for closed chats / total chats (Lõpetamise staatused / vestluste arv) (Already in Postgress DB)

    -> Get All Ended Chats

a) customer received response (byk status) (Bürokratt - klient lahkus vastusega (Bureaucrat - the client left with an answer)) b) customer did not receive response (byk status) (Bürokratt - klient lahkus vastuseta (Bureaucrat - the client left without an answer))) c) unspecified reasons when Bürokratt closes idle sessions (Bürokratt - klient lahkus määramata põhjustel (Bureaucrat - the client left for unspecified reasons)) d) accepted response - CSA involved (Nõustaja - aktsepteeritud vastusega (Wizard - with an accepted answer)) e) hate speech - CSA involved (Nõustaja - vihakõne tunnused (Advisor - signs of hate speech)) f) answered to the contact left by the customer - CSA involved (Nõustaja - vastatud teises kanalis (Advisor - answered in another channel)) g) other reasons - CSA involved (Nõustaja - muud põhjused (Advisor - other reasons))

ValterAro commented 8 months ago

Short summary: When using the English version of the page and selecting a month, then the selection of months is in Estonian. Expected result: the names of months should be in English, when English is selected. Real result: the months are shown in Estonian: How to reproduce: Go to https://admin.dev.buerokratt.ee/analytics/feedback and make sure that "en" is selected as the i18nextLng under the Local Storage under Application, when using the inspect tool. Then select selected months option. Pic:

Image

ValterAro commented 8 months ago

Short summary: There is no data for "Feedback on advisor conversations", "Feedback to selected advisor" and "Conversations with negative feedback", even though there should be from earlier conversations. This used to work in earlier versions. Expected result: there should be data for the last three feedback tabs, but there is none for any of the period. Real result: there is no data for feedback. How to reproduce: login, go to https://admin.dev.buerokratt.ee/analytics/feedback and check the last three metrics and any time period. You can also try to create a conversation and give feedback as a client. Pic:

Image

ValterAro commented 8 months ago

Short summary: in the negative feedback chats, there are duplicates of some of the chats and for these duplicates the chat end time is also 1970 for some reason. Expected result: there should not be any duplicates in the list Real result: there are duplicate conversations in the negative feedback list. How to reproduce: Pic: login and go to https://admin.dev.buerokratt.ee/analytics/feedback?page=1 then check the last 30 days of negative feedback chats.

Image

ValterAro commented 8 months ago

Seems to work as intended