--- schema_version: "1" id: d0217796c763839afcbf89e2ed3ab3188814e82499bad4199819d8f1cb5b9436 title: Calculated Insights in Segmentation collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/data/264-0-0/c360_a_calculated_insights_in_segments.md canonical_url: https://help.salesforce.com/s/articleView?id=data.c360_a_calculated_insights_in_segments.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: 41842041d0b72881823c406a0aaf96c80b247dbd5901f17dbe1e99c589cdafa2 description: Use a calculated insight to control data-driven insights in segmentation. You can also describe the calculated insight’s metrics and dimensions in a segmentation filter. products: - Data 360 release: "264" --- # Calculated Insights in Segmentation Use a calculated insight to control data-driven insights in segmentation. You can also describe the calculated insight’s metrics and dimensions in a segmentation filter. When using a calculated insight in a segment, the Segment On data model object (DMO) that you choose must be a Profile type. To use a calculated insight in a segment, go to the Segments tab in Data 360. Select the segment that you want to update, and click **Edit Rules**. Find calculated insights in the direct and related attributes library under the DMO referenced in your insight’s SQL expression. Click the insight to view the list of metrics, and then drag the metric that you want to add to the segmentation canvas. Update the operator and add a value. Optionally, you can also aggregate your data by adding dimensions to the segment by clicking **Add Dimension**. ![Insights\_in\_Segmentation](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/data_cloud/images/c360_a_insights_in_segmentation.png) Metrics - A container can include only one metric. - To define AND/OR operators between multiple metrics, add the metrics to different containers and then define. Dimensions - A container can include multiple dimensions as filter criteria for a metric. - When multiple dimensions are added, define the AND/OR operator between the dimensions. - If a calculated insight has multiple dimensions and all of them aren’t selected, the calculated insight is rolled up into a single output for the selected dimensions. For a calculated insight to appear in a segment, add the table that you segment on as a JOIN in the insights query definition. The calculated insight must also be associated with the DMO of the direct or related attribute and have a relationship with your segment. If you have two DMOs—for example, Individual and SalesOrder—the calculated insight must contain the Individual DMO’s primary key as one dimension and at least one dimension directly derived from a SalesOrder attribute to appear under the SalesOrder DMO. The segmented table’s primary key must also be a dimension in your calculated insight. See the example queries in [Github Repo](https://github.com/salesforce-marketingcloud/cdp-calculated-insights). ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/images/icon_note.png) Note You can’t use streaming insights in a segment. ## Non-Aggregatable Metrics in Segments Non-aggregatable metrics are supported in segmentation. When creating multidimensional metrics in Data 360, some calculated insight functions or metrics aren’t further aggregatable or collapsible for one or more dimensions. These measures are known as non-aggregatable metrics. When a calculated insight is defined using complex functions in a segment, the only filter available for a dimension is Equal to. A calculated insight is hidden if it includes a date-time or date dimension and contains only one non-aggregatable measure. Similarly, a non-aggregatable measure is hidden from the attribute library in the segment builder if it contains a date type dimension. A date-time dimension causes aggregating on multiple possible records, which conflicts with the non-aggregatable mechanism. #### See Also - [_Salesforce Help_: Formulas, Operators, and Calculated Insights](https://help.salesforce.com/s/articleView?id=data.c360_a_formulas__operators__and_calculated_insights.htm&release=264.0.0&type=5 "Create audiences in different ways and at different stages of your workflow using formulas, operators, and calculated insights in Data 360. During ingestion, you can use formulas to perform operations on row-based data used downstream. For segmentation, audiences are created with segment operators.") - [_Salesforce Help_: Aggregate Functions](https://help.salesforce.com/s/articleView?id=data.c360_a_calculated_insights_aggregates.htm&release=264.0.0&type=5 "Use these aggregate, datetime, analytical, formatting, math and statistical, and boolean functions when you author calculated insights in Data 360. The Aggregatable column indicates whether a function's output can be rolled up across fewer dimensions when queried in segments or activations.") - [_Salesforce Help_: Segment On](https://help.salesforce.com/s/articleView?id=data.c360_a_segment_on.htm&release=264.0.0&type=5 "Segment On defines the target object used to build your segment. You can choose an object marked as Profile or Engagement type during ingestion. For example, you can build a segment on Unified Individual, Unified Household, Account, Reservations, Sales Order, etc.")