topic Re: Calculating time from one status to another in App Development

Calculating time from one status to another

dwighttrumbower — Mon, 05 May 2025 20:23:47 GMT

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.

Re: Calculating time from one status to another

marcus_sommer — Tue, 06 May 2025 13:30:11 GMT

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.

Re: Calculating time from one status to another

dwighttrumbower — Tue, 06 May 2025 15:27:04 GMT

Thanks for the confirmation.