A Workqueue report which goes beyond what the current data source ‘Live Workqueue History’ provides

With IBM Consultant Nick Green, we’ve been developing custom management reports in Analytics – one report we haven’t been able to do however is a Workqueue report which goes beyond what the current data source ‘Live Workqueue History’ provides.

Currently, the primary fields for this report are limited to:

• Set Value (Partition)

• This Month or Last Month

• Workqueue Reviews Complete

• Workqueue Reviews Outstanding

• Percentage Complete..

• What we want to see in this source (and the custom report we will build) needs to go a level beyond this count – we want to see not only how many items were reviewed, but also

• Workqueue Starting Records (simply Reviews Complete + Reviews Outstanding, this would help make sense of the Reviewed percentage ratios)

• Workqueue Exports Complete (how many of the reviewed items were actually exported?)

• Workqueue Reorder Level Exports-OOB Complete (of those which were exported, how many were OOB – MRO IO’s default recommendation)

• Workqueue Reorder Level Exports-Non OOB Complete (manually overridden)

A nice-to-have would also be a ‘Workqueue Reorder Levels Exports-ERBS Max Complete,’ however ‘ERBS’ is a custom field specific to Petronas.

Looking back further than just one month would also be a nice-to-have.

A mock-up of the custom report we end up making with this may look like the below: (refer to attached screenshot)

This report would meet our management reporting requirements, but the deeper level of analysis provides a better understanding of user activity – for example, in cases where users are manually overriding and not accepting Optimal recommendations, in what situation (Workqueue) is this most often occurring?