MicroStrategy ONE

Graph Type: Advanced

The Advanced graph option contains the following tabs that allow you to create different subtypes of advanced graphs:

  • Stock

  • Histogram

  • 3D Surface

  • Gauge

  • Funnel

  • Pareto

  • BoxPlot

  • Gantt

  • Stock: A Stock graph is designed to plot high, low, open, and close values. It displays these values over a chosen period of time. Therefore, Stock graphs are particularly useful in depicting data that often fluctuates, such as stock prices or inventory levels. You can choose one of the following layouts for the stock graph:

  • Hi Lo: Takes two columns of data and makes a column for each row. The first column is the Hi value and is the top of the column. The second column is the Low value. The column size represents the difference between these two values.

  • Hi Lo Open: Takes three columns of data and makes a column for each row. The first column is the Hi value that is the top of the column. The second column is the Low value. The third column is the Open value that is marked on the left hand side of the Hi Low column.

  • Hi Lo Open Close: Along with the Hi, Low, and Open columns, it also contains a fourth column on the right side to indicate the Close value.

  • Histogram: A Histogram is designed to group data frequencies in a Bar graph format. Histograms capture how certain data falls within specific intervals, and are often represented as bell curves. You can choose one of the following layouts for the histogram graph:

  • Vertical: Is the standard histogram graph. It groups all the data together and based on value assigns it to categories or "buckets" that are arranged vertically. There are no series or groups in this graph type.

  • Horizontal: Groups all of the data together and based on value, assigns it to buckets that are arranged horizontally. There are no series or groups in this graph type.

  • 3D Surface: A 3D Surface graph is designed to display data points using shading, color, and multiple dimensions. It helps you analyze patterns, comparisons, and trends in data, and is especially useful to interpret the relationships between three different sets of data.

    Graphs that contain large datasets are generally good candidates to be displayed as three-dimensional surfaces because 3D Surface graphs provide a third axis on which to visually display data. You can choose one of the following layouts for the 3D Surface graph:

  • 3D Surface: Draws all data points as a three-dimensional surface, like a rolling wave.

  • 3D Surface with Sides: Draws all data points as a three-dimensional surface, with solid sides.

  • 3D Honeycomb Surface: Draws all data points as a three-dimensional surface, using a "honeycomb" effect.

  • Gauge: A Gauge graph is designed to display a specific dataset using a semicircular dial with indicators. The graph's indicators are situated within the dial's range to depict whether the monitored data is within defined limits.

  • Funnel: A Funnel graph provides another visually distinctive way of depicting report data. Funnel graphs are generally designed for conducting pipeline analyses for sales forecasts. They are also useful in illustrating the percent contribution of sales data, as they usually display data that adds up to 100%.

  • Pareto: A Pareto chart is designed to help identify the cause of a quality problem or loss. It includes a Histogram that often shows how often a specific problem is occurring or the different types of problems that are occurring. You can choose one of the following layouts for the Pareto chart:

  • Pareto: This standard configuration draws rectangular markers for all risers of the Histogram-style graph.

  • Pareto Percent: Is a dual axis pareto graph with the percent axis on the right side. A line graph is displayed as well as the standard risers. Each group in the line graph is used to calculate the percent of the total required for each series. The axis goes from zero to 100%.

  • Box Plot: Box and Whiskers: A Boxplot (sometimes called a box and whisker plot) is a graph type designed to compare similar distributions at a glance. The goal of Boxplot graphs is to make the center, spread, and overall range of values immediately apparent. The Boxplot is useful for isolating the extreme values and identifying the range of middle values in your data. For more information on Box Plot graph styles, see the Advanced Reporting Help.

  • Gantt: Gantt chart (also referred to as project time lines) are Bar graphs that help plan and monitor project development or resource allocation on a horizontal time scale.

    A Gantt chart is essentially a horizontal bar chart. Attributes are displayed along the X-axis and metrics are displayed along the Y-axis. The Gantt chart provides a graphical illustration of a schedule that can help you plan, coordinate, and track specific tasks in a project.

When you select a subtype in the dialog box, an example appears in the lower window. Click OK to apply the selected graph type to your report data.

Related topics