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.

In case you want a count of blank cells in a column, when creating the path alias you should set the value field to BLANK_STRING for the column name you choose.

Using the count function with value will not count cells with blank values, instead count another property of the cell.

For example, you can use the count function with the severity property. This will count the severity of the cells in that column even if the severity is undefined. As undefined is still considered a severity state.

Below is the syntax you would use.

value count(wpath <pathname> snoozed)

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