New Line Chart: MAU (Monthly Active Users) and WAU (Weekly Active Users) by Role

[bcastillo32]

On the /health page, add a new line chart. The chart should contain 12 months of data including the current month. The chart should track the following stats:

We are trying to track the following - please implement a toggle to display each metric on the line chart:
-MAU: count unique users by role (Volunteer, Supervisor, Admin) who logged in that month
-WAU: count unique users by role (Volunteer, Supervisor, Admin) who logged in a given week on that month

Create a json endpoint for the chart data. Make sure the json contains the minimum amount of data for the chart. Make sure the endpoint is accessible to users who are logged out.

If chart creation fails, display an error to the user explaining why. Print a detailed version of the error in the console.

No testing required but prove your solution works.

See:

https://github.com/rubyforgood/casa/blob/main/app/controllers/health_controller.rb
https://github.com/rubyforgood/casa/blob/main/app/javascript/src/display_app_metric.js

We use chart.js for graphs

See: https://github.com/rubyforgood/casa/wiki/Working-with-Frontend-Assets

[sarvaiyanidhi]

Hi @bcastillo32 .. Referring to comment from this issue #5520 (comment) I would definitely like to take up this issue. Can you please assign it to me? Thanks

[bcastillo32]

Hi @bcastillo32 .. Referring to comment from this issue #5520 (comment) I would definitely like to take up this issue. Can you please assign it to me? Thanks

thank you @sarvaiyanidhi ! :) let me know if you have any questions.

[sarvaiyanidhi]

Hi @bcastillo32 ,

For below line mentioned in issue
-WAU: count unique users by role (Volunteer, Supervisor, Admin) who logged in a given week on that month
Do you want data for each week of the current month or days for the current week of the month?

Thanks,
Nidhi Sarvaiya

[sarvaiyanidhi]

Hi @bcastillo32 .. Can you please clarify on above query related to WAU data to be shown in chart?

[bcastillo32]

Hi @bcastillo32 .. Can you please clarify on above query related to WAU data to be shown in chart?

Hi @sarvaiyanidhi - this is an interesting one. I'm not sure it make sense to break it down by the week of each month since some months have 5 weeks. Seems like it makes most sense to do "in the last 7 days" for WAU (weekly active users) - would that be a more viable option you think? I also need a way to see if are seeing more WAU over a given amount of time. So over 12 month, 3 month, 1 month, and past week. Any thoughts on how we might be able to achieve this?

[sarvaiyanidhi]

Sure @bcastillo32 .. We can show data for last 7 days for weekly active users.

For other requirement of weekly, monthly, quarterly data, are you okay to have dropdown and select appropriate option to view data as shown in below chart

[bcastillo32]

Sure @bcastillo32 .. We can show data for last 7 days for weekly active users.

For other requirement of weekly, monthly, quarterly data, are you okay to have dropdown and select appropriate option to view data as shown in below chart

Hi @sarvaiyanidhi - weekly, monthly, quarterly, yearly would all be showing WAU data over those periods so we can measure if we are seeing an increase or decrease in WAUs. Same goes for MAU. So perhaps we need 2 drop downs. One to switch from MAU and WAU and one to show the time period. Does this make sense?

[sarvaiyanidhi]

Hi @bcastillo32 I am not sure I am very clear with the requirement.

As I understand from original issue description, we need to show below two charts

-MAU: count unique users by role (Volunteer, Supervisor, Admin) who logged in that month
-WAU: count unique users by role (Volunteer, Supervisor, Admin) who logged in a given week on that month

Based on this if I understand we want to have two charts showing details as mentioned below

MAU Line Chart

• X axis will show 12 months
• Y axis with show unique count of active users for Volunteer, Supervisor and Admin in each month

WAU Line Chart

• X axis will show last 7 days
• Y axis with show unique count of active users for Volunteer, Supervisor and Admin in each day

Later I thought we also need to get for period like Quarterly Active Users so I introduced dropdown to get Quarterly, Montly, Weekly active users but I am not able to understand on two dropdowns as how are we going to compare weekly users with monthly users as both are different metrics. If possible can you clarify with more details on data you want to see in chart.