Avg duration between 2 Dates

[Samanehsorournejad]

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

[justISO]

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

avg(aggr(filecreatedate - pruefdatum, zeitpunktverarbeitung))

[Samanehsorournejad]

filecreatedate and pruefdatum have date type and zeitpunktverarbeitung has timestamp type

[justISO]

so in this case I believe even

avg(filecreatedate - pruefdatum)

should be enough. Still getting " - "?

[Samanehsorournejad]

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

[justISO]

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.