Saltar al contenido principal
waffle.svg
Domo

Running Total Stacked Bar Graph

Version 2

 

Important: When referencing this page outside of Knowledge Base, use this link: http://knowledge.domo.com?cid=runningtotalstacked

Intro

A Running Total Stacked Bar graph is similar to a vertical Stacked Bar graph, except that each successive bar in a series displays the cumulative total (or "running total") of all bars in that series up to that point. Although you can use any kind of categorical data in a Running Total graph, typically, you use date or date-time data. Other chart types in Domo that utilize this same "running total" concept include Running Total Bar graphs, which include only one series bar per category; Running Total Grouped Bar graphs, in which series bars in a category are shown side by side rather than stacked; and Running Total Line graphs, which use lines instead of bars.

Powering Running Total Stacked Bar graphs

A Running Total Stacked Bar graph requires three data columns or rows from your DataSet—one for categories, one for the series within each category; and one for values. For information about value, category, and series data, see Understanding Chart Data.

In the Analyzer, you choose the columns containing the data for your Running Total Stacked Bar graph. For more information about choosing data columns, see Applying DataSet Columns to Your Chart.

For more information about formatting charts in the Analyzer, see KPI Card Building Part 2: The Analyzer.

The following graphic shows you how the data from a typical column-based spreadsheet is converted into a Running Total Stacked Bar graph:

Customizing Running Total Stacked Bar graphs

You can customize the appearance of a Running Total Stacked Bar graph in a number of ways. Many customizations are possible by setting Chart Properties. For information about all chart properties, see Chart Properties. Unique properties of Running Total Stacked Bar graphs include the following.

Property

Description

Example

General > Number of Running Total Series

Lets you choose the number of aggregated series in most Running Total charts. Series that remain aggregated are determined by your chart series order as it appears in your legend. For example, if you had a Running Total Grouped Bar chart and you indicated that you wanted two running total series, the bars corresponding to the first two bar series in your legend would remain aggregated, and all other bars would show their literal values.

In the example, only one series has been selected as a running total series. This is the blue series at the bottom of each stack. All other series are shown with their literal values.

Category Scale > Never Use Time Scale

Determines which type of timeline is used in supported charts with time data.

By default, when time data is used in supported charts, such as Line and Bar charts, Domo automatically makes it appear using a date grain appropriate for your data. This is shown in the first example at right, in which the timeline takes date data spanning several months and shows it by month.

If you check this box, however, date data appears as it does in your DataSet. This is shown in the second example at right, in which the time scale uses individual dates, as in the DataSet.

This option is available for Vertical Bar charts only.

Value Scale > Title Position

Determines whether value scale labels in Vertical Bar charts appear to the left of the chart or above it.

Note: This property is deprecated as of our October 2016 release.

 

Changing the size of bars in a Running Total Stacked Bar graph

For any Bar graph, you can set the percentage of space taken up by bars in that graph or specify a fixed bar width. For more information, see Specifying the Size of Bars in Bar Graphs.