Greetings and Happy Holiday Season,
I'm looking for a report for backup "efficiency" purpose for our leadership and report on backup client servers that we are backing up the same amount of data over and over and over with next to zero percent change. Any reports in NBUITA that will provide this info?
have you seen this report in the library?
you can filter on metrics like
Client backup size decreased
Client backup size stayed the same
I have ran that report and I'm trying to sort out the numbers in the resulting report.
I can see:
Previous - 0
Current - 200GB
Change - 200GB
Percent Change - 100
I can also see:
Previous - 200GB
Current - 0
Change - (200GB)
Percent Change - should be -100% (negative 100% - right?)
But I find this also:
Previous - 0.00
Current - 0.00
Change GB - (0.00)
Percent Change - -12.5%
And the math here is way off:
I find it hard to believe that the difference here is a -1,173.198809%
But it IS a difference of 11,094.11 GB and should be a difference of about -92.145%
Am I right here? Taking 945.63 and dividing it by 12039.74 = 7.854%
So, 100% - 7.854% should equal 92.146% and since the data amount is a lesser amount, the percentage should be a -92.145%
the calculation for pct_change (based on the query) is
(j2.job_volume-j1.job_volume)/DECODE(j2.job_volume,0,null,j2.job_volume)*100 pct_change
(current volume - prior volume)/current_volume
and better calculation may be to use
prior - current/((prior+current)/2)
in your highlighted line, that would be 170% difference vs 1173
I think there is many ways to calculate this, whether its the difference between two numbers not a change from one number to another. Take a look at this article
https://www.calculatorsoup.com/calculators/algebra/percent-difference-calculator.php
thoughts DPeaco ZenOfAnalytics
I've created a pair of reports, one that uses Coefficient of Variation, the other that uses Interquartile range (IQR) relative to median, to highlight clients with low variability. Both are based on statistics, so the old quote "There are lies, **bleep** lies, and statistics" always comes to mind :-). I can't attach the templates here... I'll email them to you, Dennis.
ZenOfAnalytics
so the old quote "There are lies, **bleep** lies, and statistics" always comes to mind :-).
LOL!!! I get it. :-)
I got the email. I'll import the reports and see how it turns out. Thanks again kind Sir!!!!
