Version 2021

How data is aggregated on a report: metric level

When more than one attribute is on a report, as is generally the case, a metric is calculated by default at the lowest level that is on the report. As described in Hierarchies, the lowest level is usually the attribute that reflects the least-inclusive business concept, such as Day (in a Time hierarchy) or Employee (in a Geography hierarchy).

For example, imagine a report that shows your company's revenue listed by month and year. The report therefore contains the metric Revenue, and the attributes Year and Month. Is the Revenue metric going to be summed up and displayed by year? Or is it going to be summed up and displayed by month? Since a metric is calculated by default at the level of the lowest attribute that is on the report, in this example the metric results are calculated to reflect monthly sales data, since Month is a less-inclusive, or lower-level, concept than Year.

Be aware that the person who created the metrics on your report can change this default level of calculation. If you have questions about what level your metric data is being calculated for, contact your organization's MicroStrategy report designer or metric designer.