Forum Discussion
Working with timestamp data - looking at average duration. Please help!
Hi everyone! I have a table of network access data. I have IP addresses and then the date and time of when the device get on and off the network throughout the day. There are multiple associati...
Hello there clewis ! I hope I understood your question correctly. Try this:
Average =
var _min = MIN( Table[Start Timestamp] )
var _max = MAX( Table[End Timestamp] )
var _log = SELECTEDVALUE( Table[Log Timestamp] )
return
CALCULATE(
AVERAGEX( Table, _min + _max ),
Table[Log Timestamp] = _log
)
If the CALCULATE() does not work try with an IF()!
Hope this answer solves your problem! If you need any additional help please tag me in your reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
Thanks!
Best regards,
Gonçalo Geraldes
Hi Goncalo!
I need to find the difference between the last end timestamp and first start time stamp for each unique IP address each day. Then i need to take the average and plot the distribution of durations. Do you have any ideas on how to do that? It doesnt look like the above takes into consideration the different users.
Thank you!
Caiti