Skip to content

Column-to-Column Filtering

New in 5.66.1.

A filter condition can now compare one column with another, for example to keep the rows where one date is later than another. Before 5.66.1 the Filter Editor could compare a column only with a value typed into the condition. This applies to every grid in PULSE Dashboard: reports, drilldowns and the Query Analyzer.

Building a condition

  1. Open the Filter Editor from the right-click menu on a column header.
  2. Add a condition, and choose its column and its comparison.
  3. Click the icon in front of the value to switch it from a typed value to a column, then choose the second column.

Existing filters are unchanged. A condition goes on comparing with a typed value until you switch it.

Comparing Macola® text columns

Macola® stores text in fixed-width columns, so its values reach PULSE Dashboard padded with trailing spaces. The columns PULSE Dashboard calculates itself, such as the fiscal period columns, are not padded, so Equals between the two is never true. Use Begins with instead, with the Macola® column on the left.