Calculate AVG days between two dates in Set Analysis

[SkanderRadhouane]

Hello Everyone,

So I have two dates, the first one is the day where a case is created and the second one is the end date.

What I would like to calculate, is a number where I can see how many days it take to the company to resolve a case.

Thank you and Have a nice day ! 

[vikasmahajan]

create a variable using this

(date#('$(vCYEndDate)','DD/MM/YYYY')-date#('$(vCYStartDate)','DD/MM/YYYY')+1))

And use this in set analysis

Hope this helps you.

Vikas