Home profile: monthly grouped bar chart for Activity Minutes or Hours by Caregiver Role

[brylie]

Introduction

On the Home profile page, implement a new bar chart report that groups activity minutes or hours by month and caregiver role.

This is a grouped bar chart where the data are grouped by month and subgrouped by activity type with an aggregated sum of activity minutes (or hours.)

Detailed Description

• Each bar represents a month, starting from the first day of the month and including the year in the datetime. (e.g., 2023-11-01)
• The vertical height of each bar corresponds to the total sum of activity minutes or hours for that month.
• Bars are further subdivided into segments, each representing an caregiver role with its sum of minutes or hours.
• The chart should display data for the last complete year, up to the current month.

Use Case

• This report allows for a better understanding of monthly trends in resident activity.
• As a future goal: Facilitates year-on-year comparisons of activity engagement and helps in resource planning.

Technical Considerations

• The report should dynamically adjust to include the most recent 12 months of data.
• Data processing must ensure accuracy in summing and grouping the activity data.
• The chart must be visually distinct and legible, with clear legends and scaling.

Alternatives Considered

• A simple cumulative graph was considered but does not provide the granularity or seasonality of monthly caregiver roles.

Additional Context

• The new chart is expected to align with the styling and interaction of the existing grouped bar charts.
• The current charting library should be assessed for suitability with the new requirements.