Industry Insights
Tips & Tricks: Creating an Index in MetrixND
"Comparing multiple economic drivers in MetrixND can be difficult when the data series are developed in different units. Employment, reported in people, compared to GDP, reported in dollars, can wreak havoc on a graph and present useless information. When using the Graph Object as shown below, the employment and GDP comparison is meaningless when each driver is shown in their respective units.
For a meaningful comparison, the economic drivers should be converted to unitless indices before using the Graph Object. Create the indices as variables by dividing each driver by the first period value of the driver. In this example, we divide the employment and GDP series by their January 1999 values. The result of the transformed drivers is a 1.0 based index that shows a meaningful comparison in the Graph Object as shown below.
The transformation equation uses MetrixND’s Value function to obtain the January 1999 value for each of the series. The value function is designed to obtain the numerical value from a series based on the assigned year and period number.
The Employment transformation is shown below.
Table.Employment/Value(Table.Employment,1999,1)
In this transformation, the Value function is defined to access the Table.Employment variable, and obtain the value in 1999, first period. A similar equation is used for the GDP variable as shown below.
Table.GDP/Value(Table.GDP,1999,1)
While creating indices is a useful way to view the data, these indices can also be used for multiple purposes. Indices may be used directly in a model or creating a weighted average index. Try creating and using indices in your models as you develop forecasts.