Internal documentation only
This page has been marked as draft.
Toolkit | How to count number of occurrences of given value in output
Related to: Headlines | Rules | Toolkit Copied
To achieve this, you need to set up two separate headlines. After creating a new headline cell, you can configure a gateway rule to show the number of rows through the count() statistical function. Statistical functions help to make data more relevant by providing summary data rather than raw data.
Problem Copied
I have a sampler (toolkit) that returns an output table. In the headline, I want to count the number of “attached” and “detached” occurrences within the “PVC state” column. Could you please guide me on how to achieve this?
Possible solution(s) Copied
Final Output Snippet
As you can see above, I managed to count the attached and detached. The steps below show how to achieve that.
- Create the headlines here:
- I made two different rules for the attached and detached.
- Create “path aliases” for attached and detached.
- Copy the path of your headline (attached and detached).
- Paste it into the Target field
- Apply the rule that comes from this article - https://support.itrsgroup.com/hc/en-us/articles/115004029789-Geneos-How-do-I-get-the-total-number-of-rows-returned-in-a-rule-rowcount
Note: Please change the variables based on what you declared on the “PathAliases”
Then you can check how many counts are in the attached and detached. During testing:
Complete view - Tried to add the word “detached.”
Will replace the last detached with the attached.
Related article(s) Copied
- https://support.itrsgroup.com/hc/en-us/articles/115004028369-Geneos-Gateway-SQL-Using-XPath-Sources
- https://support.itrsgroup.com/hc/en-us/articles/115004028449-Geneos-Gateway-How-do-I-use-multiple-data-sources-in-gateway-SQL