Hello! We have been using MaintainX for a couple of months now, and my senior management team wants to see some KPI’s.
In our previous system, I had crafted backlog reports that listed (the total number of planned/estimated hours) minus (the total number of actual hours) for ALL our open work orders. That would equal our backlog, aka the amount of work we still have to do. Sounds simple, right?
But I can’t for the life of me figure out how to get MaintainX to give me this information!
I’ve tried looking in the canned pre-built reports AND building them manually.
The closest I’ve come is building a table that lists every open work order, with separate columns for the total estimated time (A), total time duration (B), and the result of the formula (A-B).
But I want ONE TOTAL for this one value, not a separate row for every work order.
To go one step further, I’d also like to have a report that breaks the total backlog out by Team, aka how much backlog does the HVAC team have? The BAS team? The CARP team? Etc..
Any ideas?
Thanks,
Amy Briggs
Maintenance Planner
The Jackson Laboratory, Bar Harbor, ME