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...
Hi clewis ，
In my opinion, you can count the number of unduplicated IPs in the average duration.
In the sample ,the same measure（May have to be rounded up or down, depending on whether you need） with distincount Ip.
Best Regards
Lucien
1. I dont think I understand how to do that. Can you walk me through plotting the duration distribution in this format?
2. This formula is not calculating properly. See below sample data for just Sept 20. The formula is calculating the daily average to be 5.17 hours but it should be 3.81 hours. The table below is calculating correctly for each individual IP address on a given day.