Decode the Fact Map

Depending on how you run a report, the fact map in the report results can contain values for only summary or both summary and detailed data. The fact map values are expressed as keys, which you can programmatically use to visualize the report data. Fact map keys provide an index into each section of a fact map, from which you can access summary and detailed data.

The pattern for the fact map keys varies by report format as shown in this table.

Each item in a row or column grouping is numbered starting with 0. Here are some examples of fact map keys:

Let’s look at examples of how fact map keys represent data as it appears in a Salesforce tabular, summary, or matrix report.

Tabular Report Fact Map

Here’s an example of an opportunities report in tabular format. Since tabular reports don’t have groupings, all of the record level data and summaries are expressed by the T!T key, which refers to the grand total.

Summary Report Fact Map

This example shows how the values in a summary report are represented in the fact map.

Fact Map Key	Description
0!T	Summary for the value of opportunities in the Prospecting stage.
1_0!T	Summary of the probabilities for the Manufacturing opportunities in the Needs Analysis stage.

Matrix Report Fact Map

Here’s an example of some fact map keys for data in a matrix opportunities report with a couple of row and column groupings.

Fact Map Key	Description
0!0	Total opportunity amount in the Prospecting stage in Q4 2010.
0_0!0_0	Total opportunity amount in the Prospecting stage in the Manufacturing sector in October 2010.
2_1!1_1	Total value of opportunities in the Value Proposition stage in the Technology sector in February 2011.
T!T	Grand total summary for the report.