Store the moment a value changes in a field

Red — Tue, 05 May 2026 08:54:09 GMT

Hello community,

I'm trying to do something with DQL, but I'm not even sure it's possible. To give you some context, I have a DQL query to display Control-M jobs that are retrieved using the following extension:

timeseries { avg(controlm.job.status), value.A = avg(controlm.job.status, scalar: true) }, by: { `dt.entity.controlm:job` } | lookup sourceField:`dt.entity.controlm:job`, lookupField:id, [ fetch `dt.entity.controlm:job` | fieldsAdd application, description, subapplication, orderdate ]

This query displays the status of the jobs as a percentage. For example, a job waiting to pass is at 25%, a job OK is at 100%, etc.

The problem is, there's no field that contains the information about when the job executes and passes (OK or KO). I only have the graph showing the percentage change:

My question is: is it possible to "store" the hour and minute when the value changed from 25% to 100%? The goal is to have a table, not a graph, displaying the job status and time of each job (like the one below, but with an additional column showing the exact time of each job):

If you have any suggestions, I'd appreciate them.

Best regards,

Red

topic Store the moment a value changes in a field in DQL

Store the moment a value changes in a field