AVG Interval Set Analysis

[MauriceLudo]

Hi,
I would like to know why this expression does not refer to the same result? There is a difference of 2 min

avg(interval(([Date clôture] )- ([Créé le]),'hh:mm:ss') )

avg( {<  [Canal d'entrée]={'Courrier'} >}Interval([Date clôture],'hh:mm:ss')) - avg( {<  [Canal d'entrée]={'Courrier'} >}Interval([Créé le],'hh:mm:ss'))

Best regards

Maurice

[marcus_sommer]

Your first expression contained no condition but the second does: {<  [Canal d'entrée]={'Courrier'} >} - whereby I assume you had applied the condition to the first per selection.

But there is another difference between them. The first calculates the average of the time-differences on row-level and the second returned the differences of the average of each single time-field or with other terms it's the subtraction of two aggregations.

- Marcus