- Troubleshooting
- Resources
startree-percentage-rule-query-dx
Description
Detect an anomaly if the percentage difference between the metric and the baseline is greater than the threshold. The baseline is a previous value, set with the baselineOffset
property. The threshold is set with the percentageChange
property. Aggregation function with 1 operand: SUM, MAX,etc… Use the enumeratorQuery
property to feed in a query that outputs different dimensions to explore.
Flowchart

name | description | default value | ||
---|---|---|---|---|
aggregationColumn |
| – | ||
aggregationFunction | The aggregation function to apply on the aggregationColumn. Example:
| – | ||
dataSource |
| – | ||
dataset | The dataset to query. | – | ||
monitoringGranularity |
| – | ||
timezone | Timezone used to group by time. In TZ-identifier(opens in a new tab) format. For instance, | UTC | ||
timeColumn |
| AUTO | ||
timeColumnFormat | Required if timeColumn is not AUTO. Learn more(opens in a new tab) |
| ||
completenessDelay | The time for your data to be considered complete and ready for anomaly detection. In ISO-8601 format. Example: | P0D | ||
queryFilters |
|
| ||
queryLimit |
| 100000001 |
name | description | default value | |
---|---|---|---|
baselineOffset | Offset in ISO-8601 format. Example: | – | |
percentageChange | Percentage threshold. If the percentage change is above this threshold, detect an anomaly. In ratio. Eg 0.1 means 10 percent. Learn more(opens in a new tab). | – | |
pattern | Whether to detect an anomaly if it’s a drop, a spike or any of the two. |
|
name | description | default value |
---|---|---|
daysOfWeek | Used to ignore anomalies that happen at specific time periods. A list of days. Anomalies happening on these days are ignored if timeOfWeekIgnore is true. Example: | [] |
hoursOfDay | Used to ignore anomalies that happen at specific time periods. A list of hours. Anomalies happening on these hours are ignored. Example: | [] |
dayHoursOfWeek | Used to ignore anomalies that happen at specific time periods. A mapping of
| {}
|
name | description | default value |
---|---|---|
thresholdFilterMin | Used to ignore anomalies that don’t meet the thresholdFilter min and max. Example: set | -1 |
thresholdFilterMax | Used to ignore anomalies that don’t meet the thresholdFilter min and max. Example: set | -1 |
name | description | default value | |||
---|---|---|---|---|---|
eventFilterSqlFilter | Used to ignore anomalies that happen during events. Sql filter to apply on the events. Learn more |
| |||
eventFilterLookaround | Used to ignore anomalies that happen during events. Offset to apply on startTime and endTime to look around the timeframe. In ISO-8601 format. Example: | P2D | |||
| Used to ignore anomalies that happen during events. List of event types to fetch by. Example: | [‘__NO_EVENTS’] | |||
eventFilterBeforeEventMargin | Used to ignore anomalies that happen during events. A period in ISO-8601 format that corresponds to a period that is also impacted by the event. Example: if beforeEventMargin is | P0D | |||
|
|
|
name | description | default value | |
---|---|---|---|
mutabilityPeriod | Use if your data is mutable. ThirdEye will maintain the detection results up to date on the mutable period. For instance, if your last 10 days of data is mutable, set | P0D | |
| For detection replay when data is mutable. If the percentage difference between an existing anomaly and a new anomaly on the same time frame is above this threshold, renotify. Combined with | -1 | |
reNotifyAbsoluteThreshold | For detection replay when data is mutable. If the absolute difference between an existing anomaly and a new anomaly on the same time frame is above this threshold, renotify. Combined with | -1 |
Anomaly merger
name | description | default value |
---|---|---|
mergeMaxGap | Maximum gap between 2 anomalies for anomalies to be merged. In ISO-8601 format. Example: |
|
mergeMaxDuration | Maximum duration of an anomaly merger. At merge time, if an anomaly merger would get bigger than this limit, the anomalies are not merged. In ISO-8601 format. Example: |
|
RCA
name | description | default value | |
---|---|---|---|
rcaAggregationFunction |
|
| |
rcaIncludedDimensions | List of the dimensions (columns in the dataset) to use in RCA drill-downs. If not set or empty, all dimensions of the table are used. Learn more(opens in a new tab). | [] | |
rcaExcludedDimensions
| List of dimensions (columns in the dataset) to ignore in RCA drill-downs. If not set or empty, all dimensions of the table are used. rcaExcludedDimensions and rcaIncludedDimensions cannot be used at the same time. | [] | |
rcaEventTypes | A list of type to filter on for RCA. Only events that match such types will be shown in the RCA related events tab. Learn more(opens in a new tab). | [] | |
rcaEventSqlFilter | A Sql filter for RCA events. Only events that match the filter will be shown in the RCA related events tab. Learn more(opens in a new tab).
|
|
name | description | default value |
---|---|---|
enumeratorQuery | This is a SQL query that will run on the data source and build enumeration items from that queryExample: “SELECT DISTINCT country, device from pageviews LIMIT 100”. In this case, the enumerator will generate one enumeration item for each country/device combination. | – |
enumerationItemIdKeys | List of keys to use to identify the enumeration. The format is the following:
“queryFilters” ]
The keys must be present in the The keys will be used to generate the dimension exploration id. The id will be used to identify the enumeration in the detection pipeline. | [‘queryFilters’] |