CBCity Analytics dashboard system changelog

The CBCity analytics dashboard is a lightweight platform designed to make management analysis and reporting easier than ever. It's fast, performant and reliable.

Analytics DashboardCBCity Cleanup Admin

Powered byRS9 Systems

v1.3.0 -- Heatmaps and Analytics

Release 1.3 adds a new heatmap feature, recent bookings table and various helper cards including active trucks today and missed collections for today

Improvements

  • Added a booking heatmap
  • Added a recent bookings table
  • Added a missed collections count for today
  • Added a active trucks count for today
  • Added a total bookings count for today
  • Improved styling for mattress card and lead time
  • Minified javascript for faster load time
  • Real time data for today's bookings and booking lead time

No Longer Broken

  • Lead time notification email now goes to council staff
  • Dates and times now displaying correctly
  • Calculating Lead time rounding error fixed

v1.2.0 -- Lead Time Notes

Release 1.2 adds a automatic email notification for when lead times exceed 15 days. Ensuring the waste team can monitor the contractual arrangement with the subcontractor.

Improvements

  • Lead time notification email
  • infastructure improvements, new server for processing the database sync
  • nightly sync and lead time snapshot automation
  • Total bookings for today card
  • improved dark theme handler

v1.1.0 -- Lead time feature

Release 1.1.0 adds the lead time report, unified dashboard view and dark mode. The lead time report will periodically create snapshots each week and store them for analysis. These lead time snapshots are taken every wednesday at 1am. This system also utilises a separate database for storage. This is to ensure that no performance degredation is caused to the live booking site. The analytics database is synced every night at midnight.

Improvements

  • Added dark mode support
  • Created a lead time report card
  • unified lead time report and mattress report into a single dashboard view
  • Implemented a dark theme/light theme
  • lead time data snapshots created weekly
  • Offline database sync to improve performance.
  • Styling improvments - CBCity logo with a glow and a hover effect.
  • Added changelog / docs

Initial v0.1.0

Initial release of the analytics dashboard. This dashboard will feature reports that are relevant to CBCity waste team. Initially this will just be a mattress report that can be used for end-of-month totals

Features

  • Created a mattress report
  • Ability to filter by date
  • Percentage change over previous month
  • Handling spurious bookings (for example, millions of mattresses that skew the mattress count for the month)