Multipoint rules - Data360_DQ+ - Latest

Data360 DQ+ Help

Product type
Product family
Data360 DQ+
Product name
Data360 DQ+
Data360 DQ+ Help
First publish date

Multipoint rules can be applied to any chart type.

A Multipoint rule identifies consecutive points, but this is not a strict requirement. For example, with slightly different data, the same Multipoint rule would still highlight the 3 points out of 5 that satisfied the Point Expression.

Configuring a Multipoint rule


A display name for the Multipoint rule.

The default value is "My Multipoint Rule".

Drill Fields

If your chart uses drill fields, you can use this option to specify at which level of the drill view to apply the rule. For example, if your Drill Field contains Year, Quarter, and Month levels, and you specify Month as your threshold rule's Drill Field, you will only see the application of the rule when you drill into the Month level on your chart.

Point Expression

This is the rule that will be evaluated at each point in your graph. You can create it within the Point Expression field, or press the f(x) button to build it in the Expression Editor.

When [x] out of [y] points satisfy Point Expression

This parameter is used to set the number of points that must satisfy the Point Expression in order for points to be highlighted. For example, if you were to specify 3 out of 5 points, highlighting would only occur when, for every 5 points in your chart, 3 points satisfied the Point Expression.

Aggregate Expression

Use the Aggregate Expression option to create an expression to evaluate in addition to the Point Expression. Aggregate Expressions are applied only to points that first satisfy the Point Expression; this allows you to apply an aggregation function to these points.

For example, you can apply an Aggregate Expression to the initial Multipoint example from above.

Here, the three circled points satisfy the Point Expression, but because they are not highlighted, because they don't also satisfy the Aggregate Expression.


Use Computation to specify the data point that should be highlighted when the rule is satisfied

For example, you can add another Measure to the Multipoint Rule and select this measure as the Computation option.

Even though the Point Expression deals with Measure_A, it is Measure_B that gets highlighted - at the points which correspond with the points from Measure_A that satisfy the Point Expression.