Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Count monthly inprogress ticket

Hello,

 

I would like to count the monthly/weekly unresolved tickets , here is the data sample : 

 

Category createdresolutiondate
AA11/10/2019 13:44:56null
AA03/10/2019 16:55:17null
AA06/09/2019 10:17:2611/10/2019 14:17:08
BB08/10/2019 15:20:03null
CC08/10/2019 14:46:50null
AA08/10/2019 14:40:11null
BB08/10/2019 08:34:12null
CC07/10/2019 09:46:58null
DD04/10/2019 11:58:14null
AA03/10/2019 13:08:51null
CC01/10/2019 11:31:4701/10/2019 18:56:07
DD25/09/2019 17:39:51null
BB30/09/2019 15:26:1107/10/2019 17:57:11
BB27/09/2019 09:50:46null
CC25/09/2019 16:36:14null
AA24/09/2019 16:37:1810/10/2019 15:42:18

 

The inprogress ticket is the one doesn't have the resolution date at the end of the month or the week or at the given date.

Please advise.

Thanks in advance. 

 

Tips and Tricks
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi Anonymous ,

     

    Please use ALL instead of ALLSELECTED to have a try.If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

     

    Unresolved =CALCULATE (COUNTA(Bug[created]);
FILTER( ALL(Bug);
(Bug[resolutiondate] = BLANK() || Bug[resolutiondate]> Maxx (Calendrier;Calendrier[DateSlicer] )) 
&& Bug[createddate]<=Maxx ( Calendrier; Calendrier[DateSlicer] )
)
)

8 Replies

  • PattemManohar's avatar
    PattemManohar
    Community Champion
    6 years ago

    Anonymous  Please try this as a "New Table" 

     

    Test05Out = FILTER(SUMMARIZECOLUMNS(Test05[resolutiondate],"Count",COUNT(Test05[Category ])),Test05[resolutiondate]<>BLANK())

    Use the resolutiondate as your date hierarchy column to view the counts by Month or Week

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi 

       

      Unresolved =CALCULATE (COUNTA(Bug[created]);
      FILTER( ALLSELECTED(Bug);
      (Bug[resolutiondate] = BLANK() || Bug[resolutiondate]> Maxx (Calendrier;Calendrier[DateSlicer] ))
      && Bug[createddate]<=Maxx ( Calendrier; Calendrier[DateSlicer] )
      )
      )
      Do you have any idea ? Thanks in advance. 
       

       

      • PattemManohar's avatar
        PattemManohar
        Community Champion
        6 years ago

        Anonymous Please create these two measures.

         

        Open Tickets = COUNTROWS(FILTER(Test05,Test05[resolutiondate]=BLANK()))

Closed Tickets = COUNTROWS(FILTER(Test05,Test05[resolutiondate]<>BLANK()))