Forum Discussion
Network traffic per second
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,
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 v-yulgu-msft,
I am sorry the question was not really clear, however the answer you provided worked perfectly for me!
One small thing I was wondering if the measure "Sent bytes per 10 minutes" shouldnt be like this instead:
sent bytes per 10 minutes = SUM(table8[Bytes])/(DATEDIFF(MIN(table8[Time]),MAX(table8[Time]),MINUTE)*10)
Perhaps I misunderstood the measure, but I got the feeling that you would get the result of 1 minute / 10 instead of 10 whole minutes.
Thanks!
Best regards,
L.Meijdam
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