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])
alex320's avatar
alex320
New Member
3 years ago

Thanks a lot, exactly what I needed 👍