https://store-images.s-microsoft.com/image/apps.60174.ba53e4d4-0cff-48dc-993d-649d5daf69fb.bc08bf56-e1ea-4b5c-8a72-fe1aeedd95c0.03ca381e-d7de-49da-b6b5-02ba7d5da262

Trend & Anomaly Detection

by Clear iQ Analytics

Free trial badge
Download SampleInstructions

Flag anomalies automatically with configurable standard deviation bands.

Advanced Anomaly & Outlier Detection - Flag abnormal data points with configurable deviation bands; highlight high/low anomaly zones directly on the chart. The Trend & Anomaly Detection visual helps you clearly see how performance changes over time and quickly identify unusual behavior.

It analyzes time-series data, automatically flags anomalies and outliers, and highlights when meaningful shifts begin—so you can act before small issues become costly problems. The visual accepts a measure and a time dimension as inputs, computes a rolling (moving) average over a configurable window, and calculates deviation from the moving average using standard deviation–based thresholds. Users can define the standard deviation level used for anomaly detection; data points exceeding this threshold are automatically flagged and highlighted as anomalies, with optional data labels displayed for identified outliers.

Features

Rolling Average

  1. Automatically calculate and display the rolling average based on the single measure provided.
  2. The rolling average window is determined by the user in the settings. (defaults to 8)
  3. Settings:
    • Toggle On/Off
    • Rolling Avg Window (Select number of periods)
    • Initial Periods (determines number of periods before displaying)
    • Line Color
    • Rolling Avg Line Thickness
    • Rolling Avg Line Smoothness

Outlier Bands / Outlier Markers

  1. Outlier Max/Min thresholds are calculated based on the standard deviations setting from the moving average.
  2. The Outlier Standard Deviation and Standard deviation window are determined by the user in the visual settings.
  3. The Outlier markers flag data points that fall outside of the standard deviation window (Anomalies).
  4. Settings:
    • Toggle Outlier Bands, Shaded area, and Outlier Markers On/Off
    • Outlier Initial Periods (determines number of periods before displaying)
    • Standard Deviation Window (Select Number of periods)
    • Outlier, Outlier Band, and shaded area color change
    • Shaded area Opacity %

Additional Settings

  • Trend line styling
  • Axis Title/values styling
  • Data Label Styling
    • Turn On/Off labels
    • Setting to allow data labels exclusively for outlier markers
    • Control data label frequency
  • Tooltip Styling
  • Legend On/Off Toggle and positioning setting
  • And more…

Visual capabilities

When this visual is used, it
  • Can access external services or resources

At a glance

https://store-images.s-microsoft.com/image/apps.62869.ba53e4d4-0cff-48dc-993d-649d5daf69fb.bc08bf56-e1ea-4b5c-8a72-fe1aeedd95c0.1a152880-c5cc-44f8-b702-2ae9eb41f215
https://store-images.s-microsoft.com/image/apps.26466.ba53e4d4-0cff-48dc-993d-649d5daf69fb.bc08bf56-e1ea-4b5c-8a72-fe1aeedd95c0.a14b6a89-0c0c-4bdd-9a54-81c1230c5cc3
https://store-images.s-microsoft.com/image/apps.12119.ba53e4d4-0cff-48dc-993d-649d5daf69fb.bc08bf56-e1ea-4b5c-8a72-fe1aeedd95c0.55f5e9da-5c78-44dd-8c85-a2983b531a57