topic Closure Rate using Set Analysis where Closed Date between MonthStart(Opened Date) and MonthEnd(Opened Date) in App Development

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

msshawn3019 — Sat, 03 Jun 2023 02:28:19 GMT

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])

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

sidhiq91 — Sat, 03 Jun 2023 06:04:09 GMT

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

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

Kushal_Chawda — Sat, 03 Jun 2023 20:36:23 GMT

@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])

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

msshawn3019 — Mon, 05 Jun 2023 14:17:21 GMT

This works! THANK YOU! You're amazing!