MicroStrategy ONE

Time Series Forecasting Analysis

Time series forecasting 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 Forecast Line Chart.

Forecasting analysis is available in the following ways:

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

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

Create a Forecast Analysis Line Chart

  1. Open a dashboard for editing.

  2. In the top toolbar, click Insert Visualization .

  3. Choose Insight+ > Forecast Line Chart .

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

  5. View the rendered visualization with the forecasted values on the right.

  6. The default number of forecasted points is five. To change this number, go to Format panel and click Visualization Options . In Forecast length, change the number of forecasted points. The maximum number of forecasted points is 100.

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

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

Customize the Appearance of Forecast Line Charts

Make your forecasts visually engaging by customizing the appearance of your Forecast Line Chart. Adjust colors, fonts, and labels to match your preferences and create a chart that's not only insightful, but looks great!

By default, the forecasted area of the line chart uses the first color from the chosen color palette. However, you can customize the color, data labels, markers, and divider line using the Format panel. Starting in MicroStrategy ONE (June 2024), break by functionality for forecasts allows you to format the colors and style of the forecast line and confidence band. You can customize the colors to enhance the visual distinction of different attribute elements and effectively communicate insights.