Forum Discussion

alex320's avatar
alex320
New Member
3 years ago
Solved

Average per time intervall

Hi,   I want to calculate how the average ticket handling time changes over time. I have service tickets in Jira, which take a certain time to be solved.  Ticket Closed date Duration (min) ...
Need Help
  • olgad's avatar
    olgad
    3 years ago

    Hi Alex, 
    calculate cumulative total duration, cumulative rows and dived duration by rows.

     

    Output =
    var CumulativeRows=CALCULATE(
       COUNTROWS('Table'),
        FILTER(
            ALL('Table'),
            'Table'[Closed Date]<=Max('Table'[Closed Date])
        )
    )

    var CumulativeDurationMin=CALCULATE(
       Sum('Table'[Duration (min)]),
        FILTER(
            ALL('Table'),
            'Table'[Closed Date]<=Max('Table'[Closed Date])
        )
    )

    RETURN
    Divide([Cumulative Total], [Cumulative Rows])
olgad's avatar
olgad
Resident Rockstar
3 years ago

Hi Alex, 
calculate cumulative total duration, cumulative rows and dived duration by rows.

 

Output =
var CumulativeRows=CALCULATE(
   COUNTROWS('Table'),
    FILTER(
        ALL('Table'),
        'Table'[Closed Date]<=Max('Table'[Closed Date])
    )
)

var CumulativeDurationMin=CALCULATE(
   Sum('Table'[Duration (min)]),
    FILTER(
        ALL('Table'),
        'Table'[Closed Date]<=Max('Table'[Closed Date])
    )
)

RETURN
Divide([Cumulative Total], [Cumulative Rows])