How to get CPU Demand Average delta between 2 weeks

[OsburnM]

Hey gang-- looking for some guidance.

I have a big upgrade of some code on some VMs coming up and the app owners would like a "before & after" on CPU Demand.  They'd like the "average" CPU Demand of a VM on week one along with the "average" CPU demand of a VM on week two; and then the delta between them.

Is there a way to write a View/Supermetric to do this?  Something like this...?

Thanks!

VMName	CPU Avg Demand Week 1	CPU Avg Demand Week 2	Average Delta
VM1	53%	76%	23%
VM2	47%	77%	30%
VM3	51%	74%	23%

[RickVerstegen · Accepted solution]

I guess you have to create something like this:

1. Make a super metric based on average CPU demand for VMs. Set the object type to virtual machine and enable the super metric in the policy.

2. Create a view and use the previously super metric in that view. Add the interval breakdown column and configure by week. Set time settings on the last 7 days.

3. Compare the weeks and calculate the delta yourself. It is probably possible to have this calculation also in the view but i didn't have time to figure that out at the moment.

Hope this will provide some guidance for you.

[OsburnM]

This works perfectly fine.  Would be nice to show the delta-- but we're really only comparing from week one to week two.  Thanks for the idea!

[OsburnM]

One last followup--  Turns out there's a CPU Demand % at the cluster level already w/o a supermetric that achieves more of what I'm looking for instead of looking at the VM level... so using that and combining with the above Interval Breakdown suggestion, I created a view that's very helpful.  Would still be nice to come up with a "delta" value but basic math at a cluster level between two values is easy enough all the same.