Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

NOTE: Version 2024.2 has significantly improved the way this capability works. Data field Tags are now visible by hovering over a column name or in the Data Field selection lists. And the user can now select fields from a drop down (instead of typing them in) and this will inject the column tag instead.

...

Advanced operations can be applied to data returned in a an nVISAGE report by adding a calculated column field.

...

Note

A formula typically references other columns (i.e. data fields) by name (not tag, which would be preferred, but is currently hidden form the user). If such a name is changed (by curating the Data Hub Catalog to improve the default data field names), then these formula may break. There are system reports available that will identify each report that may need to be reviewed when making such name changes. NOTE: This will be resolved in v2024.2 where the Tags will be stored instead of then column name, thus making it immune to column name changes

Info

Calculated columns can cannot reference other calculated columns but only those to the left.(yet)

Info

Calculations are always performed prior to any filters or aggregations. This is most often desired, but can be inconvenient in some situations. However more complex calculations (e.g. that also include the filtering) can often work for these situations.

...