Please try below steps
1)Create metrics definition on asset table
2) Insert and stay "metrics events" business rule change table to "Asset [alm_asset]"
3) Duration gets captured as below when state changes from "In stock" to any other state.
|
4) You can create report on "Metric_instance" table to get the records
5) If end date is empty, You can write script to get the duration by using start date and current date.
PS : Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.
This might be oversimplifying, but I do something similar to this using a Time Series report of the type Spline.
I used these settings. The users seem to find it useful as is for assets currently in stock and to see those first in and how long they've been idle since the state changed to In stock. They can of course drill into the record lists under each data point.
If you are looking to determine how much aggregate time an asset has spent In stock over its full life and across state changes, this "shortcut" is not going to help with that 🙂
