Calculate AVG days between two dates in Set Analysis

SkanderRadhouane — Sat, 16 Nov 2024 06:13:43 GMT

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 !

Re: Calculate AVG days between two dates in Set Analysis

vikasmahajan — Thu, 28 Mar 2019 10:07:40 GMT

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