Forum Discussion
Calculating daily difference on network throughput
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
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.
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.
In your world, what is a week? What is a quarter? Do you have a Calendar table that identifies the boundaries?
Do you want to show the thoughput change just week over week, or week over week to date?
your second sample file is not accessible.