Build analytics dashboard for historical refresh trends #33
Description
Feature Request
Description:
Build a dedicated analytics dashboard in the Admin UI to visualize historical trends in refresh times, failure rates, and other metrics over time.
Use Case:
Provides a high-level overview of the health and performance of the materialized view system, helping to identify long-term degradation or improvement.
Proposed Solution:
- Create a new section in the UI for 'Analytics'.
- Use a charting library (e.g., Chart.js) to display graphs of:
- Refresh duration over time (P50, P95).
- Failure rate over time.
- Number of refreshes per day.
- Allow filtering by date range.
RSpec Tests:
- Capybara System Tests:
- Seed historical refresh data.
- Visit the analytics dashboard and verify that the charts are rendered.
- Check that the data points on the chart correspond to the seeded data.
- Test the date range filter and verify the chart updates accordingly.
Checklist:
- I have searched for a similar feature request and didn't find any duplicates.
- I have included all the required information.
- I have tagged the issue with the label "enhancement".