Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |