topic Re: Avg duration between 2 Dates in App Development

Avg duration between 2 Dates

Samanehsorournejad — Wed, 05 Oct 2022 09:48:56 GMT

Hi Everyone,

I have 2 Date Type Columns named "pruefdatum" and "filecreatedate" and one column to extract day named "zeitpunktverarbeitung" my Customer wants the KPI like this:

Average duration between pruefdatum and filecreatedate

and he had told me he want pro day

I had tried this Formula but it gives me" - "as result:

=avg(aggr(date(filecreatedate) -date(pruefdatum), day(zeitpunktverarbeitung)))

pleas guide me how I should calculated this

Thanks a lot

Re: Avg duration between 2 Dates

justISO — Wed, 05 Oct 2022 10:35:12 GMT

Hi, what type are these filecreatedate and pruefdatum fields are? Timestamp? Maybe just simplify your expression to

avg(aggr(filecreatedate - pruefdatum, zeitpunktverarbeitung))

Re: Avg duration between 2 Dates

Samanehsorournejad — Wed, 05 Oct 2022 10:31:17 GMT

filecreatedate and pruefdatum have date type and zeitpunktverarbeitung has timestamp type

Re: Avg duration between 2 Dates

justISO — Wed, 05 Oct 2022 10:37:16 GMT

so in this case I believe even

avg(filecreatedate - pruefdatum)

should be enough. Still getting " - "?

Re: Avg duration between 2 Dates

Samanehsorournejad — Wed, 05 Oct 2022 10:40:12 GMT

but they want they can filter it per day and month and they want avg of difference

Re: Avg duration between 2 Dates

justISO — Wed, 05 Oct 2022 10:48:27 GMT

Now its even harder to understand the need 😕 Which fields they want to filter per day and month? filecreatedate, pruefdatum, both? This makes difference, so please provide sample data for better understanding.