How to compare cells on the same row

You need to create a rule that uses path alias with a relative path of the other cells (columns).

1. Create an additional column.

2. Create a rule with a target as the path value of the entire newly added column.

You may use relative path on the target or the absolute (full) path. Sample relative path (slow on xpath evaluation):

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

Sample absolute (full) path (fast on xpath evaluation):

/geneos/gateway[(@name="MNL_PUGO_GATEWAY_123")]/directory/probe[(@name="PUGO-NETPROBE")]/managedEntity[(@name="PUGO-MANAGED-ENTITY")]/sampler[(@name="disk_sampler")][(@type="")]/dataview[(@name="disk_sampler")]/rows/row/cell[(@column="usedInodes")]

For more information about xpath slow and fast evaluation, see How do I avoid expensive XPaths that slow down my console and Gateway.

3. Create path alias of the rows you want to compare.

Sample path aliases:

Name: totalInodes text: ../cell[(@column="totalInodes")]

Name: freeInodes text: ../cell[(@column="freeInodes")]

4. Create your rule.

Sample rule:

set $(freeInodes) path "freeInodes" value
set $(totalInodes) path "totalInodes" value
value $(totalInodes) - $(freeInodes)

5. Output