VMware Cloud Community
AEsansun2
Enthusiast
Enthusiast

Super Metric Configuration

     I am trying to create a simple super metrics to show the aggr avail in percentage.

Here is what i am using..

(Net App Aggregate: capacity|netappaggregate_total_capacity-Net App Aggregate: capacity|netappaggregate_available_capacity) /Net App Aggregate:capacity|netappaggregate_total_capacity * 100


I tried every option i know .. and it tells me "Formula expression is not valid. Cannot convert number array to number.


any thoughts ?

0 Kudos
10 Replies
sneddo
Hot Shot
Hot Shot

We don't run NetApp storage so can't really give you a definite answer, but you could try wrapping them with a sum() function to see if it resolves the issue:

(sum(Net App Aggregate: capacity|netappaggregate_total_capacity)-sum(Net App Aggregate: capacity|netappaggregate_available_capacity)) /sum(Net App Aggregate:capacity|netappaggregate_total_capacity) * 100

That should at least mean you are working with numbers rather than one of these which appears to be returning an array.



0 Kudos
AEsansun2
Enthusiast
Enthusiast

didn't help. thank you for tyring

0 Kudos
mark_j
Virtuoso
Virtuoso

Can you give the exact formulas and not the enumerated one? I can re-write for you using the wrapper functions. As sneddo mentioned, and I've discussed on other threads on the communities, you need to convert the array of #s to a single #.. and that is the error you got. TO do this, need to run it through a formula. I always suggest avg(), so that if you ave multiple data points at the same time they'll be avg'd.. anything else won't give you a generally 'true' representation of the value if there 'actually' are multiple (which is rare).

If you find this or any other answer useful please mark the answer as correct or helpful.
0 Kudos
AEsansun2
Enthusiast
Enthusiast

I tried that and it did not work.

My mistake was i was using Attr Kinds as opposed to metrics.

now it's working . Thank you

0 Kudos
mark_j
Virtuoso
Virtuoso

Attr kinds will work and should be the preferred way to do it (Axxxxx). You don't need to use metrics (M) typically. You actually don't want to use metrics M unless you absolutely have to (which is rare). Relative reference vs absolute reference..  A(ttribute) vs M(etric)..

If you find this or any other answer useful please mark the answer as correct or helpful.
0 Kudos
AEsansun2
Enthusiast
Enthusiast

well, i can't get metrics to ever work..  here is a simple conversion to TB .. no worky

avg ($RK46:A4455/1024) / 1024

avg (Net App Aggregate: Capacity|Total Capacity (MB)/1024) / 1024

0 Kudos
mark_j
Virtuoso
Virtuoso

It wouldn't work the way you have it. Try this: avg($RK46:A4455)/1048576

*Use $This for applying to a specific resource

If you find this or any other answer useful please mark the answer as correct or helpful.
0 Kudos
AEsansun2
Enthusiast
Enthusiast

ok, trying. But when you get a second, can you explain why we should only use Attr kinds and not metrics. The metrics seem to work perfectly.

thank you for your help.

0 Kudos
mark_j
Virtuoso
Virtuoso

Metrics are specific instances and don't 'always' give you a relative reference. If you want a truly relative reference, go for attribute#. However if you're target something like an instantiation, sometimes you'll need to refer to a metric#.

If you find this or any other answer useful please mark the answer as correct or helpful.
0 Kudos
NuggetGTR
VMware Employee
VMware Employee

you shouldn't need the avg or sum, and I recommend using the "This" button for metrics as it would apply to all object of that kind.

something like:

($This:M989 / 1024) / 1024

($This:Mem|Total_Capacity_Avg /1024) / 1024

works fine

For super metrics stuff here http://www.virtualiseme.net.au/index.php/vcops-super-metrics-making-more-readable-dashboards/

________________________________________ Blog: http://virtualiseme.net.au VCDX #201 Author of Mastering vRealize Operations Manager
0 Kudos