Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

time count

adilalee
Tera Contributor

adilaleepan_0-1762444652877.pngadilaleepan_1-1762444657536.png

i want to count time in particular state choice label inmaintaince | value is 3

 

1 REPLY 1

ReginaldFawcett
Tera Guru

I would suggest using Metrics to do this instead of a Business Rule. With Metrics Definitions [metric_definition] you can set the type to "Field value duration", and the field to whatever field you are looking at.
The results are found on the Metric [metric_instance] table.
It will save you a lot of time and frustration with the calculations.

Metric Definition

ReginaldFawcett_1-1762545043505.png

Metric

 

ReginaldFawcett_0-1762545017636.png