Summing Metrics with VCF Operations Views

I'd like to sum Metrics over time in VCF Operations, but Super Metrics don't support time series calculations, so what to do? View Transformations with Intervals, here's how!

The use case here is to sum ESXi Host Energy consumption over time, specifically by day. The metric itself looks like this.

You'll notice the metric is Total Energy Consumed in the collection period (Wh), by default the collection period is 5m. I created a View against the Host System Object Type using both data and metadata, a daily interval breakdown, and a Sum Transformation on the metric in question.

The Sum transformation will sum the data points over the defined interval, in this case Daily starting at Midnight each day.

Using this View (and a couple other Widgets) in a Dashboard looks like this.

Notice the list of ESXi Hosts at the top, the Interval Breakdown (day), some metadata, energy consumed during the last collection internal, and energy consumed in total during that day. You can adjust the View to be hourly, daily, monthly, etc. This is a nice alternative to Super Metrics for time series metrics. If you'd like this Dashboard (and View) you can get it here. Hope this was helpful!