Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Reaction-/Resolution time calculations (with a twist)

Hi,   I'm trying to get reaction-/resolutiontime calculations from data from our ticket system formed like this:   Ticket ID LineId Ticket created Ticket modified 38 72 2010-06-02 20:3...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Figured out something!

 

The first modified timestamp is always the same as ticket creation date. So the function always give 0 seconds for reaction time. The timestamp which is the same as "ticket created" timestamp needs to be ignored in function.

 

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Would datediff work in this scenario? I have used it before but that modified timestamp and distincting ticket ID:s gives me headache.

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion
    9 years ago

    Anonymous

     

    Hi, try with these measures.

     

    ReactionTime =
DATEDIFF (
    MIN ( Table1[Ticket created] ),
    CALCULATE (
        MIN ( Table1[Ticket modified] ),
        FILTER ( Table1, Table1[Ticket modified] <> MIN ( Table1[Ticket created] ) )
    ),
    HOUR
)
    ResolutionTime =
DATEDIFF (
    MIN ( Table1[Ticket created] ),
    CALCULATE (
        MAX ( Table1[Ticket modified] ),
        FILTER ( Table1, Table1[Ticket modified] <> MIN ( Table1[Ticket created] ) )
    ),
    HOUR
)
    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      This works! Any hints on how I can get output in Days and hours instead of full hours?

       

      Thank you very much both for contributing!

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        I'm experimenting with formula found here on forum. I changed austinsense measure to give seconds but with my Resolution-Display-measure function is calculating only full days. Any help on this? My data looks like following:

         

        Created and Modified columns are correct type:

         

         

        Reaction/Resolution -measures use following function:

         

        Reactionmeasure-seconds =
        DATEDIFF (
            MIN ( Tickets[Created] );
            CALCULATE (
                MIN ( Tickets[Muokattu] );
                FILTER ( Tickets; Tickets[Muokattu] <> MIN ( Tickets[Created] ) )
            );
            SECOND
        )

         

        ------

         

        Resolutionmeasure-seconds =
        DATEDIFF (
            MIN ( Tickets[Created] );
            CALCULATE (
                MAX ( Tickets[Muokattu] );
                FILTER ( Tickets; Tickets[Muokattu] <> MIN ( Tickets[Created] ) )
            );
            SECOND
        )

         

        Resolution-Display =
        FORMAT (
            INT (
                IF (
                    MOD ( [Resolutionmeasure-seconds]; 60 ) = 60,0;
                    MOD ( [Resolutionmeasure-seconds]; 60 )
                )
                    + IF (
                        MOD ( INT ( [Resolutionmeasure-seconds] / 60 ); 60 )
                            = 60,0;
                        MOD ( INT ( [Resolutionmeasure-seconds] / 60 ); 60 )
                            * 100
                    )
                    + INT ( [Resolutionmeasure-seconds] / 3600 )
                        * 10000
            );
            "0:00:00"
        )