Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    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

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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