How do I get the total number of rows returned in a rule?

Add Headline to Dataview

In Geneos, the samplers can add custom table cells and headlines as placeholders to display additional data.

In the sampler's Advanced tab, please scroll down to the Dataviews option and select Add New to match the sampler's dataview name (which should be the sampler's Name in most cases).

Then at the Additions button, it allows to create headlines, columns and rows to the dataview. We will be creating a new headline named rowCount.

Populate the Row Count

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.

Below is the syntax for the value count function.

value count(wpath "pathAlias" value)

"wpath" is a wildcard path and can resolve to one or many targets. The Path Alias should be configured at the rule's Advanced tab. For example, we can use the following relative path to return the column named "myColumnName" from the same dataview as the Targets path.

../../rows/row/cell[(@column="myColumnName")]

Additional Information

value count(wpath "pathAlias" value) + 0

../../rows/row/cell[(@value="")][(@column="myColumnName")]

For more information on the different functions you can apply on rules, please refer to: Where can I see a list of functions the gateway rule engine supports

There is an undocumented syntax that users may see in their legacy configurations that short-cuts the Path Alias declarations. It uses two percent signs, like this: value count(%%../../../rows/row/cell[(@column="myColumnName")] value) We strongly advise not using this and updating configurations to use Path Aliases as soon as possible.