Yammer - Time to Respond

[IvanMislav]

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

[v-shex-msft · Accepted solution]

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

[IvanMislav]

This worked. Thank you very much!