Forum Discussion

clewis's avatar
clewis
Icon for Helper I rankHelper I
5 years ago

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...
Need Help
v-luwang-msft's avatar
v-luwang-msft
Icon for Community Support rankCommunity Support
4 years ago

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

clewis's avatar
clewis
Icon for Helper I rankHelper I
4 years ago

Hi v-luwang-msft 

 

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.