cancel
Showing results for
Did you mean:
Regular Visitor

## 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

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

## Re: Yammer - Time to Respond

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

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
2 REPLIES 2
Community Support Team

## Re: Yammer - Time to Respond

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

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
Regular Visitor

## Re: Yammer - Time to Respond

This worked. Thank you very much!

Announcements