below my data can anyone please tell me

[Naresh1]

By comparing "ResolutionDeadline Date" column to "closedDate"
1. How to get count of tickets which are completed within "ResolutionDeadline date"
2. How to get count of tickets which are completed after "Resolution DeadlineDate"

 

[shiveshsingh]

create one more column, wherein  (ResolutionDeadline Date - closedDate) as FLag

1. How to get count of tickets which are completed within "ResolutionDeadline date" - count rows where FLag is positive
2. How to get count of tickets which are completed after "Resolution DeadlineDate" - count rows where FLag is negative

[DavidM · Accepted solution]

there are plenty of ways how you can do it, either create field in script and use in set analysis, use set analysis with formula, or plain if function.

Count({<[Closed Date] = {"=[Closed Date]>[Resolution Deadline Date]"}>}ID) - this is for completed after

Count({<[Closed Date] = {"=[Closed Date]<=[Resolution Deadline Date]"}>}ID) - this is for completed within resolution date

[Brett_Bleess]

Naresh, did either of the two posts help?  If so, please be sure to give credit by using the Accept as Solution button on any posts that did help you with things.  If you did something different, consider sharing that, and after you post that, you can mark that as the solution using the button I mentioned above.  If you are still trying to figure things out, please provide an update as to where you stand.

Regards,
Brett