cancel
Showing results for
Did you mean:

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Helper I

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

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
If this post helps, please consider accept as solution to help other members find it more quickly.
2 REPLIES 2
Community Support

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
If this post helps, please consider accept as solution to help other members find it more quickly.
Helper I

This worked. Thank you very much!