Forum Discussion
Network traffic per second
Hello all! I have a question about how to approach a problem I have with a calculation. My data looks like the following: Time SourceAdress DestinationAdress Bytes 10:05 10.10.1...
Hi Anonymous,
Based on my assumption, you could create measures like below, and display results in card visual.
sent bytes per seconds = SUM(table8[Bytes])/DATEDIFF(MIN(table8[Time]),MAX(table8[Time]),SECOND)
sent bytes per minute = SUM(table8[Bytes])/DATEDIFF(MIN(table8[Time]),MAX(table8[Time]),MINUTE)
sent bytes per 10 minutes = SUM(table8[Bytes])/(DATEDIFF(MIN(table8[Time]),MAX(table8[Time]),MINUTE)/10)If it doesn't meet your requirement, please provide more description about how to calculate "bytes per seconds/ per minute and per 10 minutes are sent". It would be better you can show desired putput with examples.
Regards,
Yuliana Gu
Hi Anonymous,
Yes. As you said, if the result should be 1 minute / 10 instead of 10 whole minutes, the measure should be changed to:
sent bytes per 10 minutes = SUM(table8[Bytes])/(DATEDIFF(MIN(table8[Time]),MAX(table8[Time]),MINUTE)*10)
Regards,
Yuliana Gu
Hi v-yulgu-msft,
This was exactly what I was looking for thanks for the help.
Best regards,
L.Meijdam