interval/subtraction and set analysis

[Margaret]

How can I combine this:

=avg(interval(AuditDateTime2-AuditDateTime1,'d hh:mm'))

with

<Event2={'Confirmed'}>

?

I don't know if it matters that AuditDateTime2, AuditDateTime1 and Event2 are all in the same table.

Thanks!!

[sunny_talwar · Accepted solution]

May be this:

=Avg({<Event2={'Confirmed'}>} Interval(AuditDateTime2-AuditDateTime1,'d hh:mm'))

[Margaret]

I had no idea it was that easy! Thank you again!!!!!!1