About Services Tools Blog Contact us

Optical Usage Dashboard

A practice dashboard of contact-lens prescriptions showing the mix by type, age and gender, changes due soon, and a multi-month usage forecast.

  • Reporting Dashboards
  • Optical retail
  • Dashboard feature
  • Bespoke
  • Local/private
  • 2025

The problem

A practice cannot tell from a list of prescriptions how many lenses it will need or whose replacement date is close. So ordering is a guess based on last month. Patients due a change are found by scrolling.

What it does

The page totals prescriptions by lens type, age band, gender and average lens strength. A search lists the prescriptions whose next change falls inside a chosen window, with days remaining. The forecast takes the current mix of lens types, applies a fixed monthly replacement count for each type, and projects several months ahead.

Outcomes

  • The mix of lenses is visible without a spreadsheet.
  • Patients due a change are listed with days remaining.
  • A six-month forecast gives an order quantity.
  • The horizon can be shortened without reloading the page.

Simplified mockup

Interactive preview with sample data. Nothing is sent to a server.

Prescription mix

349 active
Daily
186
53% of the book
Monthly
94
1 pair a month
Weekly
41
4 pairs a month
Extended
28
1 pair a quarter
Lens type
Age band
Gender
Mean sphere, absolute dioptres

Changes due

Inside 30 days
3
One is under a week
Soonest change
6 days
Priya Shah, daily
Boxes to pull
3
One per patient
Three prescriptions inside 30 days
PatientRefLensChange dateDays
Priya ShahLR-1044Daily16 Oct 20266
Tomos GriffithsLR-1180Monthly24 Oct 202614
Niamh ByrneLR-0902Multifocal7 Nov 202628
Inside 14 days
2
Soonest change
6 days
Dropped from view
1
Niamh Byrne, day 28
Two prescriptions inside 14 days
PatientRefLensChange dateDays
Priya ShahLR-1044Daily16 Oct 20266
Tomos GriffithsLR-1180Monthly24 Oct 202614
Inside 7 days
1
Soonest change
6 days
Call today
LR-1044
Priya Shah
One prescription inside 7 days
PatientRefLensChange dateDays
Priya ShahLR-1044Daily16 Oct 20266

Multifocal sits on a monthly replacement. Days remaining are counted from 10 October 2026.

Usage forecast

Pairs this month
5,850
Daily drives 5,580
January recall
8,400
Booked eye tests
Six-month total
38,500
Pairs to order
Predicted pairs, hundreds · Oct 2026 to Mar 2027
MonthAppointmentsPairsNote
October 2026185,850Replacement only
November 2026226,100New fits
December 2026114,800Quiet fortnight
January 2027348,400Recall month
February 2027267,000Recall tail
March 2027196,350Back to mix
Six-month view is on screen. Refetch a shorter horizon.

How it works

  1. Load patients and prescriptions.
  2. Chart the mix by lens type, age band, gender and average lens strength.
  3. List prescriptions due inside the chosen window, with days remaining.
  4. Project lens usage for several months from the current mix.
  5. Update the forecast for a shorter period without reloading the page.

Pipeline

flowchart LR
  Rx["Prescriptions"] --> Mix["Mix charts"]
  Rx --> Due["Due in 30 days"]
  Mix --> Forecast["Usage forecast"]
  Horizon["Month horizon"] --> Forecast