MicroStrategy ONE

Time Series Trend Analysis

Time series linear trend analysis is part of the MicroStrategy AI add-on bundle and is available for MicroStrategy Cloud Environment (MCE) customers starting in MicroStrategy ONE Update 11 (September 2023). Only users and user groups with the Use Auto Assistant and ML Visualizations privilege can access the Linear Trend Analysis line chart.

Linear trend analysis is available in the following ways:

  • Through the visualization gallery in a dashboard, using a drag and drop interface to create a Linear Trend Analysis Line Chart visualization.

  • Auto can utilize natural language queries to perform trend analysis.

Create Trend Analysis Line Charts

  1. Open a dashboard for editing.

  2. In the top toolbar, click Insert Visualization .

  3. Choose Insight+ > Linear Trend Line Chart .

  4. Drag a metric and time attribute from the Datasets panel to the Editor panel.

  5. View the rendered visualization. You can scroll to the right to view all provided values, if necessary.

  6. Starting in MicroStrategy ONE (June 2024), drag an attribute from the Datasets panel to Break By in the Editor panel.

  7. Starting in MicroStrategy ONE (June 2024), multiple trends render. Hover over a line to highlight specific trends and display a detailed tool tip.

Customize the Appearance of Linear Trend Analysis Line Charts

Make your trend visually stand out by customizing the appearance of your Trend Line Chart. Adjust colors, fonts, and labels to match your preferences and create a chart that's not only insightful but also looks great.

By default, the trend line takes the first color from the chosen color palette. However, users can customize the color, data labels, markers, and divider line of the trend line chart on the Format panel. Starting in MicroStrategy ONE (June 2024), for Break By, you can pick a color and style for specific trend analysis lines.