Create Dashboard with HelpRequests per day/week, most visited, etc..

[jorgeramirez]

Library options (just a quick google)

• https://c3js.org/
• https://www.chartjs.org/
• https://apexcharts.com/ (this one seems to be the most popular).

Btw, the counting part for HelpRequests it's clear. But do we have the metadata for showing how many times a request was visited? Which I assume means seen by a user.

cc @melizeche

[jorgeramirez]

Some interesting charts to consider

• X = requests Y = time, where time in {day, week, month}
• X = requests Y = visited times.
• Pie chart with %assisted and %pending. This will show from the total number of requests how many have been assisted (I think this means checking the "resolved" column).
  • We have the “resolved” column in the HelpRequest model.
• Choropleth map of help requests. On hover, show the top-k cities with requests.
  • e.g., https://github.com/voluntadpear/vue-choropleth

[melizeche]

@jorgeramirez I'll say first let's create the API endpoint to get this data Total active HR = HelpRequest.objects.filter(active=True, resolved=False).count() Total active HR unique phone numbers = HelpRequest.objects.filter(active=True, resolved=False).distinct('phone').count() Mark as resolved = HelpRequest.objects.filter(resolved=True).count() Today = HelpRequest.objects.filter(active=True, added__gte=date.today()).count() yesterday = HelpRequest.objects.filter(active=True, added__lt=date.today(), added__gte=date.today()-timedelta(days=1)).count()

After that we can choose how to visualize it

[jorgeramirez]

Yes, I guess we could do:

• /stats/requests-count?by=day|week|month
  • This service returns a count summary per day/week/month which will make it very compact. Maybe this service could return assisted and pending as two properties and within these, we have the frequency over day/week/month.
• /stats/summary
  • This will return HR total active, HR total active unique phone number, and Total HR marked as resolved.

The above covers what you mentioned.

[jorgeramirez]

Oh, you already added the summary service, great!

[jorgeramirez]

I guess we can close this issue unless there are other stats that could be added.