Palisade DocumentationBigPicture 2016 Manual Linked MapsTell me more about possible calculations in a Linked Map

Tell me more about possible calculations in a Linked Map

A linked map can not only show the relationships between topics, but it can also show rollup calculations.

Data set for the linked map

This data set lists cereal categories (through row 14) and individual cereal products (from row 15 down). The rollup calculations will apply to the categories. Because these categories don't have values for columns C to H, BigPicture requires asterisks in these columns if rollups are desired.

Data set for the linked map

Specify relationships

You first indicate how topics are linked (i.e., related).

Specify relationships

Specify desired rollup calculations

In this example, it makes sense to request averages for the four numeric columns. For example, the map will show the average price per ounce for all cereal products in the data set and for all Kelloggs products in the data set.

NOTE: The Calc Depth for Linked Maps will automatically be set to All Below.

Specify desired rollup calculations

Specify types of summaries

Under Calc Type, you can specify sums (totals), averages, minimums, or maximums.

Specify types of summaries

Specify display type

Under Display In, you can specify a Topic Note or a Topic Label. A Topic Note appears as a note below the topic with a summation sign, and a Topic Label includes the summary information in the topic's label.

Specify display type

View rollup results

Here is a sample of the category topics, where each of the average rollups is shown as a Topic Label and the Min and Max for sugar is shown as a Topic Note.