Field duration with condition

[Agata6]

Hi,
I am struggling with one issue.
I need to measure value of one field ONLY if certain conditions are met.

Good example would catalog task table and tracking value of custom field called vendor when state is 'on hold' and on hold reason is 'awaiting vendor'

I've tried couple of options:
'field value calculation' type metric - it is bad because it doesn't look at context of other fields. Vendor value stays when state or on hold reason field value changes

'script calculation' type metric - it is a little bit too complicated to me to build and maintain. I created POC and then asked myself "what if vendor changes but state and on hold reason remain unchanged?" My brain exploded.

Last option I started considering is SLA Breakdown when I can trigger SLA by on hold and state condition and then do breakdown by vendor. Sounds great but I am not able to create SLA Breakdown :< So that is dead end.

I'd love to avoid mixing & matching multiple Excel Files to find that information. Do you have any experience with such cases? Thanks

[Shannon Burns]

I know this is an old post, but did you ever figure this out.  It is exactly what I need to do and am stuck.

Thanks

Shannon

[Agata6]

Hi Shannon, unfortunately I didn't have a fix. I didn't have time to skill to code it so it is a metric which stores extra garbage information :<