Before you can create the indicator, you must identify the indicator data that you want to use. In this example, the spark
table has four columns:
Three of these columns aggregate the data that they
use:
-
The 2007 Total Sales column
sums its data.
-
The Avg Monthly Sales column
averages its data.
-
The Monthly Sales Trend column
sums its data for the sparkline.
For each of these columns, there must be enough data points in the indicator data to be aggregated.
To display a sparkline,
the data must provide the following variables:
This example uses the following indicator data:
From this indicator data, the column data used for the sparkline variables are:
-
an X-axis variable: Date
Order Was Delivered
-
a group-by variable: Product
Line
-
a metric variable: Actual
To create the sparkline, the data points that are
provided by the source data selection
Actual are
summed for each product line. Then the sum is plotted for each sparkline
by using the
Spark X axis selection
Date
Order Was Delivered. The resulting sparklines show the
trend of sales by month for each product line.