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

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

You can get the number of rows through the use of the value count statistical function.

Additional Information

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 "lines up" value)

"wpath" is a wildcard path and can resolve to one or many targets. Set the correct relative path and the column name. The relative path will depend on your "Targets" path.

If you are doing a count of a column, you should use +0 in the value setting in case the path evaluates to no cells. In the example:

value count(wpath <pathname> value) + 0

value will always display at least a 0 rather than an empty cell.

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="Delay")] value)

We strongly advise not using this and updating configurations to use Path Aliases as soon as possible.

Articles in this section

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

Comments

Articles in this section

Related articles