Closure Rate using Set Analysis where Closed Date between MonthStart(Opened Date) and MonthEnd(Opened Date)

[msshawn3019]

Trying to calculate closure rate of tickets Closed in the same month they were Opened.  My Dimension is [Opened Month-Year]

This does not work:

=Count({<[Status Code]={'C', 'N'}, [Closed Date] = {">=$(=MonthStart([Opened Month-Year]))<=$(=MonthEnd([Opened Month-Year]))"} >} Distinct [Ticket Nbr])/Count( Distinct [Ticket Nbr])

This only produces correct results for May-2023.  I need calculation for all Opened month periods.

=Count({<[Status Code]={'C', 'N'}, [Closed Date]={">=05/01/2023<=05/31/2023"} >} Distinct [Ticket Nbr])/Count( Distinct [Ticket Nbr])

[sidhiq91]

@msshawn3019  Could you please provide us sample data that would help us understand further and help you with a solution.

[Kushal_Chawda · Accepted solution]

@msshawn3019  try below

=Count({<[Status Code]={'C', 'N'},[Ticket Nbr]={"= [Closed Date] >=MonthStart([Opened Month-Year]) and [Closed Date]<=MonthEnd([Opened Month-Year])"} >} Distinct [Ticket Nbr])/Count( Distinct [Ticket Nbr])

[msshawn3019]

This works! THANK YOU!  You're amazing!