How to get the time an item stayed in consigned inventory?

Summary:

We need to get the average number of days or months a certain inventory item stayed in consigned inventory.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):