Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Calculating daily difference on network throughput

Hi all,   We're using Power BI for something different than what it normally is used for - network analysis. The principle of course stay the same.   My issue is that I have multiple countries, w...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

lbendlin , can you perhaps provide me an example? 

 

Whenever I try to use filters, I end up having to apply filtering to the point where I can only filter a single server (from the list I provided), instead of Power BI automatically picking the unique server and its throughput, and comparing it with another day.

lbendlin's avatar
lbendlin
Super User
5 years ago

here are a couple of examples based on your sample data.  What is your expected outcome?

 

 

Sum:

Average:

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks for your help so far lbendlin !

     

    Ok, so in the data set I provided, this data is collected every day, in total almost a year where every server's throughput is collected every day. I'm trying to perform a calculation whereby I'm doing a "today is x% more / less than yesterday" and a "this week is x% more / less than last week", and this quarter is x% more / less than last quarter", and so on. At the end of a week / month / quarter I can then generate a report over the different time frames and see if there was a negative growth or a positive growth in network throughput.

     

    And this is where I'm getting stuck - doing the calculation to determine the percentage growth over the different periods

    • lbendlin's avatar
      lbendlin
      Super User
      5 years ago

      This is also standard Power BI functionality.  Have a look at the Quick Measures 

      or provide some more representative test data across the desired time spans. 

       

      Caution:  comparing throughput across locations and computing averages feels a bit dangerous as it ignores the available pipe sizes. Apples and oranges, etc.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        I'm not trying to compare throughput across locations, but rather growth / decline of throughput per region and individual server.

         

        I've tried to use quick measures, but it doesn't provide the results I'm looking for.

         

        In the link (https://docs.google.com/spreadsheets/d/1ak1Z0R40uDlLFEL9JvpWaWzfoRx1qKlCrwAD6KX9ahY/edit?usp=sharing) a bigger data set across a specific month. If you can help point me how I should do the day over day or week over week, then I'll be able to figure out the rest.