cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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!

Announcements

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors