Skip to main content
waffle.svg
Domo Knowledge Base

Line Graph

Intro

A basic Line graph uses a single trendline to display data, usually for a series of dates or times. Most Line graphs display lines horizontally—that is, you scroll left or right to follow the lines. In these horizontal graphs, category data appears on the horizontal axis (x-axis) and value data appears on the vertical axis (y-axis). Domo also includes several vertical Line graphs, in which you scroll up or down to follow the lines. In vertical Line graphs, category data appears on the y-axis and value data appears on the x-axis.

Powering Line Graphs

Line graphs require only two columns or rows of data from your DataSet—one for categories (generally dates or times) and one for values. However, you can add series columns to a basic Line graph if you want. Adding series data to a Line graph may turn it into a Multi-Line graph or may simply show the two lines side by side, depending on the data.

For information about value, category, and series data, see Understanding Chart Data.

There are several different sub-types of basic Line graphs. These are built in the same way as regular Line graphs but have different features.

  • Horizontal Symbol Line

  • Horizontal Step Line

  • Horizontal Curved Line

  • Horizontal Curved Symbol Line

  • Running Total Line (discussed in more detail here)

  • Vertical Symbol Line

  • Vertical Curved Line

  • Vertical Step Line

  • Vertical Symbol Line

  • Vertical Curved Symbol Line

Note: Symbols are auto-selected based on the series. You cannot assign a specific symbol to a given series.

All of these Line graph types become Multi-Line graphs if series data is present.

For information about and screenshots of these graph sub-types, see Available Chart Types.

In the Analyzer, you choose the columns containing the data for your Line 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 basic horizontal Line graph:

The following graphic shows you how the data from a typical column-based spreadsheet is converted into a vertical Line graph:

vertical_line_spreadsheet_example.png

Customizing Line Graphs

You can customize the appearance of a Line graph by editing its Chart Properties. For information about all chart properties, see Chart Properties. Unique properties of Line graphs include the following. You can click a thumbnail image to see a larger image.

Property

Description

Example

General > Show Right Scale

Includes a second vertical scale in most kinds of multi-line Line charts, with or without date or time data. This is useful in situations where you want to display lines with vastly different value increments in the same chart. In the example at right, the left scale shows values in increments of $20,000 and the right scale shows values in increments of 2. Because two scales are present, both lines can be interpreted independently on their own scales. If there was only one scale, the $20,000 increments would be used for both lines, so one of the lines would appear flat.

This property (and General > Lines on Left Scale) can only be used in Line graphs with more than one line. All Line graph subtypes are compatible except for Step Line graphs.

General > Lines on Left Scale

When Show Right Scale is checked, determines how many of the lines in the chart are measured on the left scale. All additional lines are measured on the right scale. If Show Right Scale is not checked, this property does not work.

General > Sync Zero Lines

Syncs the zero lines in dual-scale graphs with negative values so the "0" values match. For Line graphs, this works only when General > Show Right Scale is checked.

The first example at right shows a dual-scale graph with scales that do not match. The right-side graph is being used to measure sales, which are always going to be positive; hence the scale starts at 0. However, the left-side scale is being used to measure profit, which may dip below 0. In this case the scale starts at -2000. Because the scales do not match, the graph is difficult to interpret.

The second example shows the same graph with the zero lines synced. Even though the other values do not match, the viewer can easily use the zero line as a reference point to interpret the line and bars simultaneously.

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 not available for Step Line graphs.

Grid Lines > Remove Min/Max/Avg Lines

Removes the minimum, maximum, and average lines that normally display on mouse-over in standard Bar and Line graphs.

Last Value Projection > Project Using

Determines whether a final value is projected in Bar and Line graphs and, if so, how this value is determined. You can enter a specific value for a projection or set Domo to project a value automatically by...

  • taking the current value for the period and comparing it to the previous period (forecasting),

  • taking the average of the previous points in the graph, or

  • using a linear regression.

The example at right shows a Line graph in which a final value has been projected using a linear regression. For more information, see Projecting the Last Value in Your Chart.

Last Value Projection > Projection Value

Lets you specify the final projected value in a Bar or Line graph. This only works if you have selected Specified Value as the Project Using property. For more information, see Projecting the Last Value in Your Chart.

Last Value Projection > Previous Values to Average

Lets you specify the number of points to average to determine the final projected value in a Bar or Line graph. This only works if you have selected Average Previous Values as the Project Using property. For more information, see Projecting the Last Value in Your Chart.

Scale Marker Range > Minimum Value

Lets you specify the minimum value for a scale marker range in a Line graph. This value makes up the bottommost border of the range in the graph. The example at right shows a typical Line graph in which a scale marker range has been set, with the arrow pointing out the minimum value of the range. For more information, see Adding a Scale Marker Range to Your Chart.

Scale Marker Range > Maximum Value

Lets you specify the maximum value for a scale marker range in a Line graph. This value makes up the topmost border of the range in the graph. The example at right shows a typical Line graph in which a scale marker range has been set, with the arrow pointing out the maximum value of the range. For more information, see Adding a Scale Marker Range to Your Chart.

Scale Marker Range > Color

Lets you select the color for the scale marker range in a Line graph. For more information, see Adding a Scale Marker Range to Your Chart.


 

Scale Marker Range > Show Lines

Determines whether minimum and maximum lines are shown for scale marker ranges in Line graphs. For more information, see Adding a Scale Marker Range to Your Chart.


 

Scale Marker Range > Fill Outliers

Determines whether outlier regions (that is, regions of a line falling outside of a scale marker range) are filled in Line graphs in which scale marker ranges have been set. The example at right shows a typical Line graph in which a scale marker range has been set, with arrows pointing out the filled outliers. For more information, see Adding a Scale Marker Range to Your Chart.

General > Show as Running Totals

Lets you specify whether lines appear with running totals in several kinds of horizontal Line charts. In other words, each point in a series line displays the cumulative total of all points in the line up to that point.

The example screenshots show the same Curved Line chart without and with running totals. In the first example, Show as Running Totals is off so the chart appears with each data point reflecting only the new data up to that point. In the second example, Show as Running Totals is on so each data point reflects all of the data in the line up to that point.

This property is available for the following kinds of Line graphs: Curved Line, Step Line, Symbol Line, and Curved Symbol Line. Several types of charts have built-in running total functionality, so there is no need to set a chart property. These include the following: Running Total Bar graphs, Running Total Grouped Bar graphs, Running Total Stacked Bar graphs, and Running Total Line graphs.

Regression Line > Show Linear Regression Line 

Allows you to add a regression line to your Line chart. Regression lines are available for most Line chart subtypes.

In the example at right, the dashed orange line represents the regression line. 

Regression Line > Include Last Data Point 

Determines whether the last data point in your Line chart is included in the calculation for the regression line. If your chart shows a timeline that is not complete (for example, November appears as the last month in the timeline but has not yet ended), you should check this box.

Regression Line > Line Style 

Lets you specify whether your regression line is solid or dashed (default). 

Regression Line > Line Color 

Lets you select the color for the regression line. 

Outlier Filtering > Show When Points Above

Filters your Line graph to show only those lines with any values above the value you specify. Note that any values above this threshold count toward this filter. So if you entered 5000 for this value, and only one point exceeded 5000, the line would still appear. 

If you enter a value in Show When Points Above that is less than the value you enter in Show When Points Below, only lines with all points between these two values are displayed.

For more information about this property, including examples, see Filtering Outliers in a Line Graph.

Outlier Filtering > Show When Points Below

Filters your Line graph to show only those lines with any values below the value you specify. Note that any values below this threshold count toward this filter. So if you entered 5000 for this value, and only one point fell below 5000, the line would still appear. 

If you enter a value in Show When Points Below that is greater than the value you enter in Show When Points Above, only lines with all points between these two values are displayed.

For more information about this property, including examples, see Filtering Outliers in a Line Graph.

Adding Regression Lines -- VIDEO

 

 

Note: The product training videos are for Domo customers and clients only.