Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I'm trying to calculate the average of the difference between modified dates with different filters.
The field is called 'Modified date' and is changed when there is a status change
I'm trying to calculate the avg difference of the modified date field when:
1. the status field is equal to "Closed"
2. the status field is equal to "New"
Trying to use the below calculation without success:
= avg (({<[Status] = {'Closed'}>} [Modified Date] ) - {<[Status] = {'New'}>} [Modified Date])
Thanks for your help!