Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
This worked. Thank you very much!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |