This post is more than 5 years old
6 Posts
0
1198
October 20th, 2016 15:00
How to count the amount of values in a table column
Hey all,
I have a table with a about 80 rows. One of the columns shows different values.
Which formula should i use and how to configure it to count f.e. the existence o the value 50.
So if 10 of the rows contain the value 50 in the specific column i need the value 10 to be returned.
Thanks
No Events found!
isakats
141 Posts
0
October 25th, 2016 06:00
Hi RolfCo,
Here is a quick proof of concept for the gauge you are trying to setup.
(in my setup the majority of ports are inactive)
On the "List of Port Node" (the one you copied) i added the Availability formula and filter on "name=='LinkStatus'"
The parent node is the gauge report, where the threshold are defined in the Report Details
HTH
Regards,
Isaka
isakats
141 Posts
0
October 21st, 2016 06:00
Hi RolfCo,
I think that you might be able to achieve this with the OverThresholdCount formula, quick note that the result of the value count would have to be in the parent node of your current table.
Regards,
Isaka
RolfCo
6 Posts
0
October 21st, 2016 13:00
Thanks for the anwser. I tried it but it is not giving the result i would expect.
As child report i took a copy from the VNX SP ports summary report. I have 80 ports with a link status of 100.
I want to count the values 100 to create a gauge chart. 80x link status 100 is normal, 78x 100 is minor etc.
When i put the formula in this report
I do get a result like this
80.00 is the result from the Util.Child count. So yes i do have 80 ports. Percentage over 95, yes 100%, but Over Threshold Count and a Value Count of 2.00? It does not make sense to me?
isakats
141 Posts
0
October 24th, 2016 07:00
Hi RolfCo,
Your use case is not what i had understood, one of the availability formulas might be a better fit. Also i am not seeing the same port summary report in my lab, yours seem to contain much more information then the stock one...was it customized ?
Regards,
Isaka
RolfCo
6 Posts
0
October 24th, 2016 08:00
Hi Isaka,
Sorry i try to create multiple reports and try to work arround the challenge i am facing...
The report i use is nearly the original report (Report Library, EMC VNX, Inventory, Block Components, Storage Processors). I only changed the Link Status to show the value.
I am missing the clue somewere on how to use the formula. Many part have the name "Availability", but how to use this in the formula.
I configured a formule like below, but it is not returning the desired result.
RolfCo
6 Posts
0
October 26th, 2016 00:00
Thanks! That worked!