|Some plugins like FKM and SQL-Toolkit have built-in options to show counters as headline cell. This article talks about the configuration to achieve the same for other plugins. We will create a new headline for the row count as an example.|
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.
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