Data best suited for
|
Spark tables should be used when sparklines can add useful information at a glance for the user. Sparklines provide simple
linear graphic representations of complex data. Spark trend lines should be used in spark tables when individual data points
do not have to be displayed in line chart format. In other words, a general trend should give the business user a sense for where the data is heading, but not every data
point on the spark table has to be revealed in order to get value out of the table. Use spark tables when there is ample data
to form trend lines and when data can translate into a status to create ranges for small KPIs.
|
Target audience
|
Some audiences might not be familiar with sparklines. However, sparklines are designed to be easy to interpret, so even if
users are unfamiliar with this indicator type, they should be able to understand it. Adding graphics to the spark table provides
context for the user that might improve
understanding. Audiences that might be familiar with this indicator type include business analysts, business users, executives,
and financial analysts.
|
Data aggregation support
|
You can configure a spark table indicator to aggregate data, and you can select the type of aggregation to use for each column
in the spark table.
|
Range support
|
Ranges are optionally supported.
|
Alert support
|
Alerts are supported only if a range is associated with the indicator. For information, see
Customizing Alerts.
|
Link support
|
This indicator type can be used to define a link or as the destination of a link. For
more information about defining an indicator with a hyperlink, see
Adding Links to Indicators or Other Content.
|
Interaction support
|
|
Filter multiple items
support
|
Filtering multiple items is supported. For
more information, see
Supporting Multiple Selections in a Filtered Data Interaction.
|
Display Setting
|
Selection Used for Figure
|
---|---|
Spark group by
|
Product Line
|
Spark X axis
|
Date Order Was Delivered
|
Column Setting
|
Selection Used for Figure
|
---|---|
Source data
|
Actual
|
Column title
|
Set to Monthly
Sales Trend
|
Column width (%)
|
Set to 50
|
Aggregate function
|
Sparkline is
selected.
|
Function
|
Description
|
---|---|
Start
|
Displays the starting
data value of the source data on a gauge for each row.
|
End
|
Displays the ending
data value of the source data on a gauge for each row.
|
Total
|
Displays the total of
the source data on a gauge for each row.
|
Average
|
Displays the average
of the source data on a gauge for each row.
|
Minimum
|
Displays the minimum
data value of the source data on a gauge for each row.
|
Maximum
|
Displays the maximum
data value of the source data on a gauge for each row.
|
Sparkline
|
Displays the source
data as a trending graph for each row.
Note: In order for a sparkline
to appear, the Spark Group by
property must be set.
|
Date Order Was Delivered
(Spark X axis)
|
Product Line
(Spark group by)
|
Actual
(Source data)
|
---|---|---|
2007JAN
|
Children
|
127348.2
|
2007JAN
|
Clothing
|
390431.7025
|
2007JAN
|
Outdoors
|
331445.64
|
2007JAN
|
Sports
|
555983.2925
|