Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
May be this:
=Avg({<Event2={'Confirmed'}>} Interval(AuditDateTime2-AuditDateTime1,'d hh:mm'))
May be this:
=Avg({<Event2={'Confirmed'}>} Interval(AuditDateTime2-AuditDateTime1,'d hh:mm'))
I had no idea it was that easy! Thank you again!!!!!!1