Forum Discussion
Count distinct cases between 2 measures
Super Useryour sample data is inconstent (especially the last close date)
Does it matter how long a case was open? What if it is open for more than one month? More than 3 months?
I apologize. I was not able to post a photo of my table and had to manually create the results. I have updated the table to reflect the accurate information. As to your question, it does not matter how long a case is open. There are times a case can be open for 1 year then closed and that case should be counted in that specific fiscal period since it was closed. Which it currently is being counted in my resolved column since it was open before the specific fiscal period, in this case Apr-2019. This type of example is the first row. The case was opened before the fiscal period but closed during that period. My Resolved measure is calculating that correctly but it does not seem to be getting counted in the Total Fiscal Resolved of cases closed or open during that fiscal month.