Several customers have asked whether it is possible to add a performance measure on the total utilization of an object, defined as the sum of several states (e.g. travel empty, travel loaded, loading, ... but not idle, blocked, maintenance).
I figured out a way to get it right once, which is fairly complex: create a Pie Chart using the State Pie Template, set up the utilization calculation in the convenient interface, then Install the template, and add a performance measure along the lines of
Table.query("SELECT
SUM(Utilization) FROM [State Pie 1 Collector]")[1][1]
However, if I do want to include or exclude states later, I either have to re-do all these steps or manually change the calculation of the Utilization field in the statistics collector to add a line
totalTime += state.getTotalTimeAt(2); // What do these magic numbers mean?
Anyway, what I'm getting at, is that it would be useful to add such a PFM in a more convenient way - for example by allowing PFMs to sample internal statistics collectors of charts; or at the very least allow the Table.query command to access them, so I don't have to Install the template but I can add a PFM directly for
Table.query("SELECT
SUM(Utilization) FROM COL:/[State Pie Chart]")[1][1]
or something like that.
