Hi all, this may seem like a simple question, but I find myself stuck at the moment. I am looking to define a query in the work order tracking application to return records that have a work log. Eventually I want to build in some qualifiers like status and date ranges, but this should be what I need to get started.
I may also look to define a KPI of percentage of completed work orders in a previous 30 day period that have work logs as a percent of the total number of completed work orders.
As you might guess, we are trying to encourage the use of worklogs on work orders where appropriate and want to set a baseline of where we are now and track it over time. Any help is greatly appreciated. Thanks!
#WorkManagement------------------------------
Tim Pratt
Bates College
------------------------------