Saltar al contenido principal

Domo University Videos

Domo

Projecting the Last Value in Your Chart

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

Intro

In Line, Bar, and Grouped Bar with Line graphs, you may find it useful to show how the data might be expected to change in the near future. Domo provides the ability to create such a "data projection." This data projection gives viewers an idea of how the data might change between the current value of a chart and the next future value.

Note: Although Last Value Projection properties appear in Chart Properties for Multi-Line graphs, these properties work only when the graph contains only one series.

In a Line graph, a dotted line is used to show how far the data value is expected to fall or drop. In the following example, the data value is expected to fall to about 3,000, based on a linear regression:

Likewise, a dotted line is used in a Bar graph to show the expected change. A region of different color above the current value indicates an expected increase in the data; a dotted line below the current value indicates an expected drop. In the following example, the user created a projection based on the average of the three values prior to the last value:

For a Grouped Bar with Line graph, you can choose to apply a projection to either the last bar or last line that appears in the graph. 

Types of Projections

There are three possible types of projections in Domo. These are as follows:

Projection Type

Description

Forecast Value

Domo forecasts the value of the remainder of the current period in your chart. It does this by taking the current value for the period and comparing it to the previous period. For example, in the following chart, the current month, October, is not yet over, so the user applies the Forecast property. The light blue represents the forecasted value for the entire month of October.

Specified Value

You specify the projected value yourself. When you select this option, you must enter the desired value in the Projection Value field.

Average Previous Values

Domo calculates the projection based on the average of a specified number of values prior to the current value. You specify the number of values in the Previous Values to Average field.

Linear Regression

Domo calculates the projection based on a linear regression of your data.

Creating a Projection

You can add a projection to your Line, Bar, or Grouped Bar with Line graph in the Chart Properties.

To add a projection to your graph,

  1. Open the Analyzer for the Line, Bar, or Grouped Bar with Line graph you want to edit.

  2. In Chart Properties, click Last Value Projection (for a Bar or Line graph) or Last Bar Value Projection or Last Line Value Projection (for a Grouped Bar with Line graph).

  3. Select the projection type in the Project Using menu.

  4. (Conditional) If you select Specified Value, enter the desired value in the Projection Value field.

  5. (Conditional) If you select Average Previous Values, enter the number of previous values for which you want to take the average.

Use Cases

The following projection use cases were introduced in the Domopalooza 2017 Tips and Tricks session. For more tips and tricks, see Tips and Tricks: Quick Lessons from Power Users.

  • If your data is showing steady growth, you may want to use Linear Regression to best predict your end of period performance.

  • If your data has a strong end-of-period trend, use Forecast Value will likely give you the projection you want.

  • If your data has a lot of variability in it, you may need to experiment with Forecast Value, Average Previous Values, Linear Regressions, or a manual entry.