Calculating time from one status to another

[dwighttrumbower]

Basic columns are:

Product, ActivityNo, Status(Quote, Ordered), Date

The same activityno is used when a product is quoted and then another record is created with same activityno when it moves to ordered.  The date is when the record gets created.

I would like to create a KPI to show the AVG time a product goes from Quote to Ordered. 

1. Get date diff for Activity, quote and Activity, ordered. 

2. Show Avg for date diff based by Product. 

I'm not sure this can be done with set analysis but I'm wondering if it could.

On load, the date diff could be calculated per activity.

[marcus_sommer · Accepted solution]

It couldn't be done with set analysis because this is just a way to adjust the selection state behind a calculation.

I suggest to calculate the diff within the data-model and then something like:

sum(Diff) / count(distinct YourFields)

will return the avg.

[dwighttrumbower]

Thanks for the confirmation.