Multipoint rules - Data360_DQ+ - Latest

Data360 DQ+ Help

Product type
Software
Portfolio
Verify
Product family
Data360
Product
Data360 DQ+
Version
Latest
Language
English
Product name
Data360 DQ+
Title
Data360 DQ+ Help
Copyright
2024
First publish date
2016
ft:lastEdition
2024-07-09
ft:lastPublication
2024-07-09T15:09:58.774265

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

Name

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.

Computation

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.