Network traffic per second

[Anonymous]

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.10.10	99.99.99.99	10
10:10	11.11.11.11	66.66.66.66	20
10:15	11.11.11.11	67.67.67.67	10
10:20	11.11.11.11	66.66.66.66	12
10:25	12.12.12.12	77.77.77.77	24
10:30	10.10.10.10	77.77.77.77	30

It is connected to a database that updates these fields automatically. Now what I would like to achieve is to calculate how much bytes per seconds/ per minute and per 10 minutes are sent. 

I am not sure how to approach this so it would be greatly appreciated if someone could help/ give me a push in the right direction!

(tips about how to visualise this type of data are also very welcome)

Thanks in advance,

L.Meijdam

[v-yulgu-msft · Accepted solution]

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

[Anonymous]

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

[v-yulgu-msft]

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

[Anonymous]

Hi @v-yulgu-msft,

This was exactly what I was looking for thanks for the help.

Best regards,

L.Meijdam