---
schema_version: "1"
id: 95999c7f136a3b531790da92f68dd8251d6a37a296adc4bd59327ac34affde9b
title: Considerations for Data 360 Reports on Calculated Insights
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/rd_dc_reports_calculated_insights_limits.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.rd_dc_reports_calculated_insights_limits.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 97aaa85cd2c00a85db4ae9f39d9846909c52afe4810a6723bdc673c8c3308050
description: Keep these considerations in mind when working with Data 360 reports on calculated insights.
products:
  - Cross Cloud
release: "264"
---
# Considerations for Data 360 Reports on Calculated Insights

Keep these considerations in mind when working with Data 360 reports on calculated insights.

## Calculated Insight Reports

Keep these considerations in mind when building reports on calculated insights.

- Measures are treated as aggregates and dimensions are treated as groupings, and they aren’t interchangeable. All possible aggregates (measures) and groupings (dimensions) are added to reports by default.
- To create a report from a calculated insight, you must include at least one aggregate measure with a non-text data type and at least one dimension. You can’t create reports on calculated insight that don’t have measures or dimensions.
- To include non-aggregatable measures in a report, first include all the dimensions from the calculated insight.
- A calculated insight report displays as a summary report without details.
- A calculated insight report doesn’t show grand totals and row count.
- You can’t add row-level and summary formulas to a column.
- You can’t perform aggregates, such as sum, min, max, and average on a measure.
- Non-aggregatable measures in a report don’t show subtotals.
- To build a report on a calculated insight with more than five dimensions, include at least one aggregatable measure in the report.
- For calculated insights with more than five dimensions and both aggregatable and non-aggregatable measures, you can build reports with up to five dimensions and all aggregatable measures. To add a dimension when five dimensions are present, delete an existing dimension from the report.
- You can’t remove a grouping from a report with only non-aggregatable measures.
- When you remove a dimension from the report, all non-aggregatable measures are also removed. When you add a dimension back to the report, you must add the measures you want.
- You can’t export a calculated insight report using the Details Only option.

## Charts in Calculated Insight Reports

Keep these considerations in mind when adding charts to a calculated insight report.

- When you remove a dimension or measure from the report that is included in its chart, the chart refreshes to display valid data if possible. Otherwise, the report doesn’t display the chart anymore and you can’t add another chart to the report.
- You can’t add non-aggregatable measures to the report’s chart until you add all the dimensions to the chart.
- Data 360 dashboards have all the restrictions that a report chart has. Additionally, the tabular, metric, and gauge components aren’t available for a calculated insight report.

This table shows different scenarios for working with charts in Data 360 reports and the considerations to keep in mind for each of the scenarios.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:17.879746835443036%">
          <col style="width:15.822784810126581%">
          <col style="width:16.297468354430382%">
          <col style="width:16.297468354430382%">
          <col style="width:16.297468354430382%">
          <col style="width:17.405063291139243%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" id="d57710e132">Number of Dimensions in the Report</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d57710e135">Number of Dimensions in the Chart</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d57710e138">Type of Measure in the Report</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d57710e141">Default Behavior</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d57710e144">Unavailable Chart Types</th>
            <th scope="col" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" id="d57710e148">Considerations</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Number of Dimensions in the Report" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e132 ">1 dimension</td>

            <td data-label="Number of Dimensions in the Chart" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e135 ">1 dimension </td>

            <td data-label="Type of Measure in the Report" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e138 ">Non-aggregatable measures and aggregatable measures</td>

            <td data-label="Default Behavior" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e141 ">The chart displays the non-aggregatable measure. Both aggregatable and
              non-aggregatable measures are available in the chart editor.</td>

            <td data-label="Unavailable Chart Types" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e144 ">
              <ul>
                <li>Stacked bar</li>

                <li>Stacked column</li>

              </ul>
            </td>

            <td data-label="Considerations" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e148 ">&nbsp;</td>

          </tr>
          <tr class="">
            <td data-label="Number of Dimensions in the Report" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e132 ">2 dimensions </td>

            <td data-label="Number of Dimensions in the Chart" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e135 ">1 dimension</td>

            <td data-label="Type of Measure in the Report" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e138 ">Non-aggregatable measures only</td>

            <td data-label="Default Behavior" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e141 ">The chart displays both dimensions.</td>

            <td data-label="Unavailable Chart Types" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e144 ">
              <ul>
                <li> Donut </li>

                <li>Funnel </li>

              </ul>
            </td>

            <td data-label="Considerations" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e148 ">You can’t remove the dimensions from the chart. </td>

          </tr>
          <tr class="">
            <td data-label="Number of Dimensions in the Report" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e132 "> 2 dimensions </td>

            <td data-label="Number of Dimensions in the Chart" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e135 ">1 dimension </td>

            <td data-label="Type of Measure in the Report" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e138 ">Non-aggregatable measures and aggregatable measures</td>

            <td data-label="Default Behavior" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e141 ">The chart displays the aggregatable&nbsp;measure by default.</td>

            <td data-label="Unavailable Chart Types" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e144 ">&nbsp;</td>

            <td data-label="Considerations" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e148 ">You can’t add non-aggregatable measures to the chart until you add the second
              dimension.</td>

          </tr>
          <tr class="">
            <td data-label="Number of Dimensions in the Report" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e132 ">2 dimensions</td>

            <td data-label="Number of Dimensions in the Chart" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e135 "> 2 dimensions</td>

            <td data-label="Type of Measure in the Report" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e138 ">Non-aggregatable measures and aggregatable measures</td>

            <td data-label="Default Behavior" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e141 ">&nbsp;</td>

            <td data-label="Unavailable Chart Types" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e144 ">&nbsp;</td>

            <td data-label="Considerations" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e148 ">
              <ul>
                <li>If you remove a dimension from the table or the chart when the chart includes
                  a non-aggregatable measure, an aggregatable measure replaces the
                  non-aggregatable measure in the chart.</li>

                <li>If you remove all aggregatable measures from the chart, and not all dimensions
                  are present in the chart, the chart refreshes and displays both the&nbsp;dimensions
                  and only non-aggregatable measures. To revert the change, click Undo.</li>

              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Number of Dimensions in the Report" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e132 ">3 or more dimensions</td>

            <td data-label="Number of Dimensions in the Chart" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e135 ">&nbsp;</td>

            <td data-label="Type of Measure in the Report" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e138 ">Non-aggregatable measures only</td>

            <td data-label="Default Behavior" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e141 ">&nbsp;</td>

            <td data-label="Unavailable Chart Types" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e144 ">&nbsp;</td>

            <td data-label="Considerations" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e148 ">You can’t add a chart to the report.</td>

          </tr>
          <tr class="">
            <td data-label="Number of Dimensions in the Report" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e132 ">3 or more dimensions</td>

            <td data-label="Number of Dimensions in the Chart" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e135 ">&nbsp;</td>

            <td data-label="Type of Measure in the Report" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e138 ">Non-aggregatable measures and aggregatable measures</td>

            <td data-label="Default Behavior" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e141 ">The chart displays the aggregatable measure. Only aggregatable measures are
              available in the chart editor.</td>

            <td data-label="Unavailable Chart Types" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e144 ">&nbsp;</td>

            <td data-label="Considerations" class="slds-cell-wrap" style="vertical-align:top;" headers="d57710e148 ">
              <ul>
                <li> You can’t add non-aggregatable measures to the chart. </li>

                <li>If you remove all aggregatable measures from the chart, the report doesn’t
                  display the chart anymore and you can’t add another chart to the report.</li>

              </ul>
            </td>

          </tr>
        </tbody>
      </table>

## Calculated Insight Reports in Dashboards

Keep these considerations in mind when adding a calculated insight report and chart to a dashboard.

- All calculated insight report and chart behavior applies to the dashboard components using them.
- Tabular, metric, and gauge components aren’t available.