Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
@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 Could you please provide us sample data that would help us understand further and help you with a 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])
This works! THANK YOU! You're amazing!