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?
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.
I hope you are doing well.
I saw your note mentioning the two reports you created—one based on the Coefficient of Variation and the other using Interquartile Range (IQR) relative to the median—to highlight clients with low variability. I found the approach very interesting and quite useful from a statistical perspective.
Would it be possible for you to share those templates with me as well? They would be very helpful for similar analysis and validation on my side.
Thank you in advance for your time and support.
Best regards,
Julio Quitian
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%
