Creating a Dashboard Chart

Objective

After completing this lesson, you will be able to Create a dashboard chart.

Analytics Chart

SAP Integrated Business Planning (IBP) for Supply Chain allows you to analyze and visualize your data as charts, and to collect the charts on a dashboard for easy access. You can use the Analytics Advanced application to analyze your data, and to create and customize charts. In the Dashboard Advanced application, you can organize and present charts and other information on a single UI to ensure convenient access.

The Analytics Advanced application provides a detailed view of all reports and Key Performance Indicators (KPIs), and provides a chart creation tool. It enables you to customize how you display your data (visualizations) in a chart, bar graph, or data set. You can create visualizations from various sources, including importing them from SAP Sales and Operations Planning (S&OP) from your company network or from your items.

To display the Analytics Advanced application, choose the corresponding tile on the SAP Fiori launchpad. The Analytics Advanced application allows you to do the following:

  • Query your data (filter).

  • Group your data to visualize it in a meaningful way.

  • Save visualizations as a chart to a library that you can easily add to your custom dashboards.

  • Share your charts with other users or export them to a file.

Note

By default, all charts and dashboards are public. You can make charts and dashboards private by changing the parameters on the Global Configuration screen in the Configuration application. To make a chart or dashboard private, change the CHARTS PUBLIC parameter or the DASHBOARDS_PUBLIC parameter to false.

Comparison Chart Type

Different sets of data are suited to a specific chart type. The following table describes the comparison chart type, which is available for selection in the Analytics application:

Comparison Chart Type

Analysis Type

Chart Type

Purpose

Comparison

Bar

A chart that illustrates comparisons along individual items. Categories are organized along the vertical axis, and values along the horizontal axis.

Use this chart when you have one or more data series to plot and you want to compare data for multiple categories. Data contains positive, negative, and zero values. The displayed values are durations.

Column

Column chart, displays or compares several sets of data. This type of chart is best suited for displaying data for several sets over a period of time.

Dual X-Axis Bar

Allows you to compare data sets that have different units of measure. This chart type is used for comparing trends or relationships between two variables (for example, key figures), which may have different magnitudes and scales of measurement.

Dual Y-Axis Bar

Used for comparing trends or relationships between two variables (for example, key figures), which may have different magnitudes and scales of measurement. This chart type is useful when you have limited real estate and you want to quickly establish the relationship between two variables.

Heat Map

A graphical representation of data where the individual values contained in a matrix are represented as colors. Fractal maps and tree maps both often use a similar system of color-coding to represent the values taken by a variable in a hierarchy.

Table

Data is presented in a simple table form.

Vertical WaterfallThis chart illustrates the cumulative increase, decrease and total result for a set of key figures along a vertical axis
Horizontal WaterfallThis chart illustrates the cumulative increase, decrease and total result for a set of key figures along a horizontal axis
Waterfall with Time DimensionThis waterfall chart illustrates the cumulative evolution of key figure values over time.

Key figure values can be inverted from positive to negative or from negative to positive, and reordered.

Trend Chart Type

The following table describes the trend chart type:

Trend Chart Type

Analysis TypeChart TypePurpose
TrendLineA line chart displays data as a series of points connected by a line. This type of chart is best suited for showing data for a large number of groups (for example, total sales over the past several years).
Dual Y-Axis LineUsed for comparing trends or relationships between two variables (for example, key figures), which may have different magnitudes and scales of measurement. This chart type is useful when you have limited real estate and you want to quickly establish the relationship between two variables.
Dual Y-Axis CombinationThe combination chart is a visualization that combines the features of the bar chart and the line chart. The combination chart displays the data using a number of bars or lines, each of which represent a particular category. A combination of bars and lines in the same visualization can be useful when comparing values in different categories, because the combination gives a clear view of which category is higher or lower. An example of this can be seen when using the combination chart to compare the projected sales with the actual sales for different time periods.
CombinationThis chart combines the features of the bar chart and the line chart. The combination chart displays the data using a number of bars or lines, each of which represent a particular category. A combination of bars and lines in the same visualization can be useful when comparing values in different categories, since the combination gives a clear view of which category is higher or lower.
Dual X-Axis CombinationUsed for comparing trends or relationships between two variables (for example, key figures), which may have different magnitudes and scales of measurement. It combines the data categories represented by bars and lines.

Distribution Chart Type

The following table describes the distribution chart type:

Distribution Chart Type

Analysis TypeChart TypePurpose
DistributionHorizontal and Vertical Bar StackedA stacked bar chart displays data as a series of vertical bars. This type of chart is best suited for representing three series of data, with each series represented by a color stacked in a single bar, for example, cost for a series of years.
PieA pie chart displays data as a pie, split and filled with color or patterns. Pie charts are typically used for one group of data (for example, the percentage of consumption for an asset). However, you have the option to choose multiple pie charts for multiple groups of data.
DonutA donut chart is similar to a pie chart, displaying data as sections of a circle or donut. If, for example, you charted consumption by region on a particular report, you would see the total consumption (the figure) in the center of the donut and the regions as colored sections of the donut. As with the pie chart, you have the option to choose multiple donut charts for multiple groups of data.
Dual Stacked ColumnThis allows you to place multiple series on a chart and separate them vertically, so you can visualize all of the data at once.
Dual Stacked BarThis allows you to place multiple series on a chart and separate them horizontally, so you can visualize all of the data at once.
ScatterIn scatter plots the X values being graphed usually form a continuous series, like time.

Geographic Chart Type

The following table describes the geographic chart type:

Geographic Chart Type

Analysis TypeChart TypePurpose
NetworkChoroplethThis is a map that uses differences in shading, coloring, or the placing of symbols within predefined areas to indicate the average values of a quantity in those areas.
Geo PieA pie chart displays geographical data as a pie, split and filled with color or patterns.
Geo BubbleThis is a map of a country, a continent, or a region with areas identified by circles or bubbles.

Log in to track your progress & complete quizzes