Forum Discussion

IvanMislav's avatar
IvanMislav
Icon for Helper I rankHelper I
10 years ago
Solved

Yammer - Time to Respond

Hi,

 

I've exported files from yammer to get a better insight in activites on the network. I would like to calculate time of response for each message and consequently, average time to reply for the whole network.

 

There are following columns:

 

id: message id

replied_to_id: id of message on which id responded

thread_id: original thread 

created_at: timestamp, format  dd/mm/yyyy hh:mm:ss (G)

 

Does anyone have an idea how can I calculate average time to respond based on this columns?

 

Thanks

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    Hi IvanMislav,

     

    If the table store all the threads' create time, you can use below measure to get the average reply minute:

     

    Average = 
var replayID=LASTNONBLANK(Sheet1[Replied_to_id],[Replied_to_id])
return
AVERAGEX(ALL(Sheet1),if(replayID<>BLANK(), DATEDIFF(LOOKUPVALUE(Sheet1[Create_at],Sheet1[id],replayID),max([Create_at]),MINUTE),BLANK()))

     

     

    Regards,

    Xiaoxin Sheng

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Hi IvanMislav,

     

    If the table store all the threads' create time, you can use below measure to get the average reply minute:

     

    Average = 
var replayID=LASTNONBLANK(Sheet1[Replied_to_id],[Replied_to_id])
return
AVERAGEX(ALL(Sheet1),if(replayID<>BLANK(), DATEDIFF(LOOKUPVALUE(Sheet1[Create_at],Sheet1[id],replayID),max([Create_at]),MINUTE),BLANK()))

     

     

    Regards,

    Xiaoxin Sheng