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
Patient
Ref
Lens
Change date
Days
Priya Shah
LR-1044
Daily
16 Oct 2026
6
Tomos Griffiths
LR-1180
Monthly
24 Oct 2026
14
Niamh Byrne
LR-0902
Multifocal
7 Nov 2026
28
Inside 14 days
2
Soonest change
6 days
Dropped from view
1
Niamh Byrne, day 28
Two prescriptions inside 14 days
Patient
Ref
Lens
Change date
Days
Priya Shah
LR-1044
Daily
16 Oct 2026
6
Tomos Griffiths
LR-1180
Monthly
24 Oct 2026
14
Inside 7 days
1
Soonest change
6 days
Call today
LR-1044
Priya Shah
One prescription inside 7 days
Patient
Ref
Lens
Change date
Days
Priya Shah
LR-1044
Daily
16 Oct 2026
6
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
Month
Appointments
Pairs
Note
October 2026
18
5,850
Replacement only
November 2026
22
6,100
New fits
December 2026
11
4,800
Quiet fortnight
January 2027
34
8,400
Recall month
February 2027
26
7,000
Recall tail
March 2027
19
6,350
Back to mix
Six-month view is on screen. Refetch a shorter horizon.
Refetched · 3 months JSON route
Order 0. January’s recall sits outside this horizon.
How it works
Load patients and prescriptions.
Chart the mix by lens type, age band, gender and average lens strength.
List prescriptions due inside the chosen window, with days remaining.
Project lens usage for several months from the current mix.
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