Intro
In many kinds of line and bar charts, 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 "data projections." Data projections give viewers an idea of how the data might change between the current value of a chart and upcoming future values.
Data projections come in two types—Last Value Projections and MultiPeriod Projections. Last Value Projections project only the last value in your chart, but you can use several different kinds of calculations to make the projection, including linear regression, averaging the previous values, etc. MultiPeriod Projections let you project as many future periods as you want, either by using included controls to add and remove periods or by manually entering the desired number in Chart Properties. However, all multiperiod projections are based on linear regression (though a number of different options are available for configuring your linear regression).
Last Value Projections
Last Value Projections let you project one future value onto your chart. These are available for the following chart types:

Vertical single bar

Vertical grouped bar

Vertical stacked bar

Line bar

Multiline bar

Line with grouped bar

Line

Multiline

Curved line

Symbol line

Curved symbol line
In line charts, dotted lines are used to show how far data values are expected to fall or drop when a Last Value Projection is applied. In the following example, the data value is expected to rise to about $27,000, based on a linear regression:
You could also set projections in a chart with multiple lines, like in the following example:
Likewise, a dotted line is used in a bar chart 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:
You could also set projections in a chart with grouped or stacked bars, like in the following example:
For a grouped bar with line chart, you can choose to apply a projection to either the last bar or last line that appears in the chart (or both).
Video  Using Last Value Projections
Types of Last Value Projections
There are four possible types of Last Value 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 Last Value Projection
You can add a Last Value Projection to your chart in the Chart Properties.
To add a projection to your chart,

Open the Analyzer for the chart you want to edit.

In Chart Properties, click Last Value Projection (for a bar or line chart) or Last Bar Value Projection or Last Line Value Projection (for a grouped bar with line chart).

Select the projection type in the Project Using menu.

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

(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 endofperiod 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.
MultiPeriod Projections
MultiPeriod Projections allow you to add unlimited projections to your chart. These are available for the following chart types:

Vertical single bar

Vertical grouped bar

Vertical stacked bar

Vertical running total bar

Vertical running total grouped bar

Vertical running total stacked bar

Line

Multiline

Curved line

Symbol line

Curved symbol line

Running total line
Chart types in which MultiPeriod Projections are available include "+" and "" controls for adding and removing projections. These appear at the bottom right of the chart, like in the following example:
Clicking the "+" button adds a new projected data point to the chart (using the selected Project Using option in Chart Properties > MultiPeriod Projection), and clicking the "" button removes a projection. You can add as many projections to a chart as you want. In the following example, the user added three projections to his chart. The first projection is "added" to the last data point of March 23rd, and the second and third follow the same date pattern already established in the data, becoming new projected data points, March 24th and 25th.
These controls are available in the Details view, meaning anyone with access to the card can add or remove periods (unless you choose to restrict this option by removing the controls, which you can do in Chart Properties).
You can also enter a number of projected periods manually in Chart Properties > MultiPeriod Projection > Projection Period Count.
Understanding Properties for MultiPeriod Projection
A number of chart properties are available for tuning your multiperiod projections.
Projection Type 
Description 


Remove Controls 
When this box is checked, the "+" and "" controls for adding projections are removed from your chart. 

Projection Period Count 
Lets you manually enter a set number of projection periods to your chart. 

Project Using 
Determines how your projection periods are calculated. The following options are available:


Repeating Pattern  Lets you specify the number for the repeating sequence of data points used in your timeline. For example, a weekly timeline would have a pattern of 7 (for 7 days); a quarterly timeline would have a pattern of 3 (for 3 months); and so on. If you do not specify a value, Domo will make its best guess as to your pattern. 
Creating a MultiPeriod Projection
You can add a MultiPeriod Projection to your chart in the Chart Properties. (You can also add projections in the Details view or Analyzer using the controls, as described previously, though this does not give you any configuration options.)
To add a MultiPeriod Projection to your chart,

Open the Analyzer for the chart you want to edit.

In Chart Properties, click MultiPeriod Projection.

Enter the number of periods you want to project in the Projection Period Count field.

Select the projection type in the Project Using menu.

(Optional) To indicate the pattern you want Domo to look at when calculating your future periods, enter the number of data points in the pattern in the Repeating Pattern field. For example, if you wanted Domo to determine future periods based on a repeating 10day period, you would enter 10 here.
Comments
0 comments
Please sign in to leave a comment.