---
schema_version: "1"
id: 10f05e438ff144cc8542931c2caf42a48b4c7aee895ca77600382343971c38f0
title: Agentforce Observability Dimension Formulas
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/ai/264-0-0/generative_ai_agent_analytics_dimension_formulas.md
canonical_url: https://help.salesforce.com/s/articleView?id=ai.generative_ai_agent_analytics_dimension_formulas.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 2af1e44197abfb895fd4dccd347283f3fce0517241fcb0e7f55e38a960ebf4f4
description: Use these formulas to understand how Agentforce Observability calculates dimensions in the Agentforce Analytics Foundations semantic data model.
products:
  - Agentforce
  - Cross Cloud
release: "264"
---
# Agentforce Observability Dimension Formulas

Use these formulas to understand how Agentforce Observability calculates dimensions in the Agentforce Analytics Foundations semantic data model.

## Session Outcome and Status Fields

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small " summary="Dimension Formulas">
        <caption>Dimension Formulas</caption>
        <colgroup>
          <col style="width:23.076923076923077%">
          <col style="width:15.384615384615385%">
          <col style="width:30.76923076923077%">
          <col style="width:30.76923076923077%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d199015e48">Label</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d199015e51">CX Description</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d199015e54">Field Name</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d199015e57">Formula</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e48 ">Abandon Status</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e51 ">Indicates whether a session is abandoned. A session must not be escalated, must have an abandonment score of TRUE, and must have a deflection score of 3 or lower.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e54 ">Abandonment_Status_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e57 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>IF IFNULL({ FIXED [AI_Agent_Session].[AI_Agent_Session_Id] : MAX([Escalation_Status_clc]) }, FALSE) = FALSE AND { FIXED [AI_Agent_Session].[AI_Agent_Session_Id] : MAX(IF [AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag_Definition2_Source_Tag_Reference] = 'std_Abandonment_Score' AND [Is_Latest_Session_Scorer_clc] = TRUE THEN [AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag2_Value] END) } = 'TRUE' AND IFNULL(INT({ FIXED [AI_Agent_Session].[AI_Agent_Session_Id] : MAX(IF [AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag_Definition2_Source_Tag_Reference] = 'std_Deflection_Score' AND [Is_Latest_Session_Scorer_clc] = TRUE THEN [AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag2_Value] END) }), 0) &lt;= 3 THEN TRUE ELSE FALSE END</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e48 ">Deflection Status</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e51 ">Indicates whether a session is deflected. A session must not be escalated and must have a deflection score above 3.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e54 ">Deflection_Status_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e57 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>{ FIXED [AI_Agent_Session].[AI_Agent_Session_Id] : IFNULL(MAX([Escalation_Status_clc]), FALSE) = FALSE AND INT(MAX(IF [AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag_Definition2_Source_Tag_Reference] = 'std_Deflection_Score' AND [Is_Latest_Session_Scorer_clc] = TRUE THEN [AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag2_Value] END)) &gt; 3 }</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e48 ">Engagement Status</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e51 ">Indicates whether the session includes at least one engaged interaction.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e54 ">Engagement_Status_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e57 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>{ FIXED [AI_Agent_Session].[AI_Agent_Session_Id] : MAX(
IF [Is_Interaction_Engaged_clc]
THEN TRUE
ELSE FALSE
END) }</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e48 ">Escalation Status</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e51 ">Indicates whether a session was transferred to another agent at session end or after 24 hours without activity.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e54 ">Escalation_Status_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e57 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>{ FIXED [AI_Agent_Session].[AI_Agent_Session_Id] : MAX(
IF 
(
[AI_Agent_Interaction_Step].[Ai_Agent_Interaction_Step_Type]='SESSION_END' 
OR
DATEDIFF('HOUR', { FIXED [AI_Agent_Session].[AI_Agent_Session_Id] : MAX([AI_Agent_Interaction].[End_Timestamp]) },NOW()) &gt;= 24
)
AND
[AI_Agent_Interaction_Step].[Name]='CLOSED_TRANSFERRED'
THEN TRUE
ELSE FALSE
END )}</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e48 ">Is Session Ended</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e51 ">Indicates whether a session has a SESSION_END event or has been inactive for at least 24 hours.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e54 ">Is_Session_Ended_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e57 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>{ FIXED [AI_Agent_Session].[AI_Agent_Session_Id] : MAX(
  IF [AI_Agent_Interaction].[Ai_Agent_Interaction_Type]='SESSION_END'
  OR DATEDIFF('HOUR', { FIXED [AI_Agent_Session].[AI_Agent_Session_Id] : MAX(
  						[AI_Agent_Interaction].[End_Timestamp]) },
                        NOW()
             ) &gt;= 24
  THEN TRUE
  ELSE FALSE
  END
  )
}</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e48 ">Session Ambiguous</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e51 ">Indicates a session that is not escalated, has a low deflection score, and is not marked as abandoned.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e54 ">Is_Session_Ambiguous_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e57 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>IF IFNULL({ FIXED [AI_Agent_Session].[AI_Agent_Session_Id] : MAX([Escalation_Status_clc]) }, FALSE) = FALSE AND IFNULL(INT({ FIXED [AI_Agent_Session].[AI_Agent_Session_Id] : MAX(IF [AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag_Definition2_Source_Tag_Reference] = 'std_Deflection_Score' AND [Is_Latest_Session_Scorer_clc] = TRUE THEN [AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag2_Value] END) }), 0) &lt;= 3 AND { FIXED [AI_Agent_Session].[AI_Agent_Session_Id] : MAX(IF [AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag_Definition2_Source_Tag_Reference] = 'std_Abandonment_Score' AND [Is_Latest_Session_Scorer_clc] = TRUE AND ([AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag2_Value] = 'FALSE' OR [AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag2_Value] = 'Unsure') THEN TRUE ELSE FALSE END) } = TRUE THEN TRUE ELSE FALSE END</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e48 ">Session Outcome</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e51 ">Classifies the session outcome as Escalated, Unengaged, Deflected, Abandoned, Not Resolved, Not Abandoned, or Not set.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e54 ">Session_Outcome_Base_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e57 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>IF IFNULL({ FIXED [AI_Agent_Session].[AI_Agent_Session_Id] : MAX([Escalation_Status_clc]) }, FALSE) THEN 'Escalated' ELSEIF [Engagement_Status_clc] = FALSE THEN 'Unengaged' ELSEIF IFNULL({ FIXED [AI_Agent_Session].[AI_Agent_Session_Id] : MAX([Deflection_Status_clc]) }, FALSE) THEN 'Deflected' ELSEIF IFNULL([Abandonment_Status_clc], FALSE) THEN 'Abandoned' ELSEIF IFNULL([Is_Session_Ambiguous_clc], FALSE) THEN 'Not Resolved, Not Abandoned' ELSE 'Not set' END</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e48 ">Session Duration</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e51 ">For an ended session, shows the seconds from the first turn start to the last turn end.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e54 ">Session_Duration_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e57 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>{ FIXED [AI_Agent_Session].[AI_Agent_Session_Id] : MAX(
    IF [Is_Session_Ended_clc]
    THEN DATEDIFF( 'SECOND',
    { FIXED [AI_Agent_Session].[AI_Agent_Session_Id] : 
        MIN( IF [AI_Agent_Interaction].[Ai_Agent_Interaction_Type]='TURN' 
        THEN [AI_Agent_Interaction].[Start_Timestamp]
        END
        ) },
    { FIXED [AI_Agent_Session].[AI_Agent_Session_Id] : 
        MAX(IF [AI_Agent_Interaction].[Ai_Agent_Interaction_Type]='TURN' 
        THEN [AI_Agent_Interaction].[End_Timestamp]
        END
        ) }
    )
    END 
) }</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e48 ">Is Sub Session</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e51 ">Indicates whether the session continues from an earlier session.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e54 ">Is_Sub_Session_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e57 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>IF NOT (ISNULL([AI_Agent_Session].[Previous_Session_Id]) OR [AI_Agent_Session].[Previous_Session_Id] = 'NOT_SET')
THEN TRUE
ELSE FALSE
END</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e48 ">Is Interaction Engaged</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e51 ">Indicates whether the interaction includes one or more user messages.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e54 ">Is_Interaction_Engaged_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e57 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>[Total_User_Messages_Per_Interaction_clc] &gt; 0</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e48 ">Is Interaction With Errors</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e51 ">Indicates whether any step in the interaction contains an error.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e54 ">Is_Interaction_With_Errors_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e57 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>{ FIXED [AI_Agent_Interaction].[AI_Agent_Interaction_Id] : MAX([Is_Step_With_Error_clc]) }</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e48 ">Is Step With Error</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e51 ">Indicates whether an interaction step contains a meaningful error message, excluding placeholder and no-error values.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e54 ">Is_Step_With_Error_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e57 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>IF NOT ISNULL([AI_Agent_Interaction_Step].[Error_Message]) AND LEN(TRIM([AI_Agent_Interaction_Step].[Error_Message])) &gt; 0 AND [AI_Agent_Interaction_Step].[Error_Message] != 'NOT_SET' AND [AI_Agent_Interaction_Step].[Error_Message] != 'None' AND NOT (CONTAINS([AI_Agent_Interaction_Step].[Error_Message], '"message":"None"') AND CONTAINS([AI_Agent_Interaction_Step].[Error_Message], '"source":"mgr.step.error"')) THEN TRUE ELSE FALSE END</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e48 ">Is User</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e51 ">Indicates whether the participant is a user or messaging end user.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e54 ">Is_User_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e57 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>IF
	[AI_Agent_Session_Participant].[AI_Agent_Session_Participant_Role]='USER'
AND
	[AI_Agent_Session_Participant].[Participant_Object] IN ('MessagingEndUser','User')
THEN TRUE
ELSE FALSE
END</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e48 ">Is User Turn</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e51 ">Indicates whether the interaction is a turn from a user.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e54 ">Is_User_Turn_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e57 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>IF [Is_User_clc] AND [AI_Agent_Interaction].[Ai_Agent_Interaction_Type] = 'TURN' THEN TRUE ELSE FALSE END</code></pre>
            </td>

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

## Scorer, Feedback, and Quality Fields

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small " summary="Dimension Formulas">
        <caption>Dimension Formulas</caption>
        <colgroup>
          <col style="width:23.076923076923077%">
          <col style="width:15.384615384615385%">
          <col style="width:30.76923076923077%">
          <col style="width:30.76923076923077%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d199015e347">Label</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d199015e350">CX Description</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d199015e353">Field Name</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d199015e356">Formula</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e347 ">Agent Adherence Status</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e350 ">Shows the Instruction Adherence evaluation category for generated interaction steps.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e353 ">Agent_Adherence_Status_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e356 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>{ FIXED [AI_Agent_Interaction_Step].[AI_Agent_Interaction_Step_Id] : MAX(IF NOT ISNULL([AI_Agent_Interaction_Step].[Generation]) AND [AI_Agent_Interaction_Step].[Generation] != 'NOT_SET' AND [Ai_Content_Quality_Category].[Detector_Type] = 'InstructionAdherence' THEN [Ai_Content_Quality_Category].[Category] END) }</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e347 ">Task Resolution Status</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e350 ">Shows the latest Task Resolution evaluation category for generated steps in the session.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e353 ">Task_Resolution_Status_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e356 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>{ FIXED [AI_Agent_Session].[AI_Agent_Session_Id] : MAX(
    IF NOT ISNULL([AI_Agent_Interaction_Step].[Generation]) 
    AND [AI_Agent_Interaction_Step].[Generation] != 'NOT_SET' 
    AND [Ai_Content_Quality_Category].[Detector_Type] = 'TaskResolution'
    AND [AI_Agent_Interaction_Step].[Start_Timestamp] = 
        { FIXED [AI_Agent_Session].[AI_Agent_Session_Id] : MAX(
            IF NOT ISNULL([AI_Agent_Interaction_Step].[Generation]) 
            AND [AI_Agent_Interaction_Step].[Generation] != 'NOT_SET' 
            AND [Ai_Content_Quality_Category].[Detector_Type] = 'TaskResolution'
            THEN [AI_Agent_Interaction_Step].[Start_Timestamp] 
            END
        ) }
    THEN [Ai_Content_Quality_Category].[Category] 
    END
) }</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e347 ">Quality Score</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e350 ">Shows the moment quality score as a whole number.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e353 ">Quality_Score_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e356 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>INT([AI_Agent_Moment_Quality_Score_lv].[AI_Agent_Tag1_Value])</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e347 ">User Feedback Status</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e350 ">Shows Positive or Negative based on the most recent feedback for the interaction, or N/A when no feedback exists.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e353 ">User_Feedback_Status_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e356 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>IFNULL({ FIXED [AI_Agent_Interaction].[AI_Agent_Interaction_Id] : MAX(IF [Ai_Feedback].[Timestamp] = { FIXED [AI_Agent_Interaction].[AI_Agent_Interaction_Id] : MAX([Ai_Feedback].[Timestamp]) } THEN CASE [Ai_Feedback].[Feedback] WHEN 'GOOD' THEN 'Positive' WHEN 'BAD' THEN 'Negative' END END) }, 'N/A')</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e347 ">Is Intent Scorer Standard</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e350 ">Indicates whether an intent scorer is a standard scorer.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e353 ">Is_Intent_Scorer_Standard_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e356 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>IF 
    LEFT([AI_Agent_Tag_Definition].[Source_Tag_Reference], 4) = 'std_'
    OR 
    [AI_Agent_Tag_Definition].[Developer_Name] = 'Quality_Score'
THEN TRUE
ELSE FALSE
END</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e347 ">Is Interaction Scorer Standard</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e350 ">Indicates whether an interaction scorer is a standard scorer.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e353 ">Is_Interaction_Scorer_Standard_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e356 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>IF 
    LEFT([AI_Agent_Interaction_Tag_Association_lv].[AI_Agent_Tag_Definition3_Source_Tag_Reference], 4) = 'std_'
THEN TRUE
ELSE FALSE
END</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e347 ">Is Session Scorer Standard</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e350 ">Indicates whether a session scorer is a standard scorer.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e353 ">Is_Session_Scorer_Standard_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e356 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>IF LEFT([AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag_Definition2_Source_Tag_Reference], 4) = 'std_'
OR [AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag_Definition2_Source_Tag_Reference] = 'Quality_Score'
OR [AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag_Definition2_Source_Tag_Reference] = 'AIE_Request_Category'
THEN TRUE
ELSE FALSE
END</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e347 ">Is Latest Intent Scorer</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e350 ">Indicates whether this is the most recently created scorer result for the moment and scorer.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e353 ">Is_Latest_Intent_Scorer_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e356 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>[AI_Agent_Tag_Association].[Created_Date] = 
{ FIXED [AI_Agent_Tag_Association].[AI_Agent_Moment_Id], 
        [AI_Agent_Tag_Definition].[Tag_Identifier] : 
  MAX([AI_Agent_Tag_Association].[Created_Date]) }</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e347 ">Is Latest Interaction Scorer</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e350 ">Indicates whether this is the most recently created scorer result for the interaction and scorer.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e353 ">Is_Latest_Interaction_Scorer_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e356 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>[AI_Agent_Interaction_Tag_Association_lv].[AI_Agent_Tag_Association4_Created_Date] = 
{ FIXED [AI_Agent_Interaction_Tag_Association_lv].[AI_Agent_Tag_Association4_AI_Agent_Interaction], 
        [AI_Agent_Interaction_Tag_Association_lv].[AI_Agent_Tag_Definition3_Tag_Identifier] : 
  MAX([AI_Agent_Interaction_Tag_Association_lv].[AI_Agent_Tag_Association4_Created_Date]) }</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e347 ">Is Latest Session Scorer</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e350 ">Indicates whether this is the most recently created scorer result for the session and scorer.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e353 ">Is_Latest_Session_Scorer_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e356 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>[AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag_Association3_Created_Date] = 
{ FIXED [AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag_Association3_AI_Agent_Session_Id], 
        [AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag_Definition2_Tag_Identifier] : 
  MAX([AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag_Association3_Created_Date]) }</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e347 ">Custom Scorer Semantic Type</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e350 ">Classifies a custom scorer as a Measurement or Dimension based on its defined semantic type or data type.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e353 ">Custom_Scorer_Semantic_Type_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e356 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>IF NOT ISNULL([AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag_Definition2_Semantic_Type]) 
AND LEN(TRIM([AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag_Definition2_Semantic_Type])) &gt; 0
THEN [AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag_Definition2_Semantic_Type]
ELSEIF [AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag_Definition2_Data_Type] = 'Integer' 
OR [AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag_Definition2_Data_Type] = 'Number' 
THEN 'Measurement'
ELSE 'Dimension'
END</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e347 ">Custom Scorer Measures</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e350 ">Shows the identifier for an active nonstandard scorer that can be used as a measure.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e353 ">Custom_Scorer_Measures_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e356 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>IF [Custom_Scorer_Semantic_Type_clc] = 'Measurement'
AND [AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag_Definition_Association3_Is_Active] = TRUE
AND [Is_Session_Scorer_Standard_clc] = FALSE
AND (
    [AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag_Definition2_Source_Type] = 'Predefined'
    OR
    [AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag_Definition2_Source_Type] = 'OpenEnded'
)
THEN [AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag_Definition2_Tag_Identifier] 
ELSE '--'
END</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e347 ">Custom Scorer Dimensions</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e350 ">Shows the identifier for an active nonstandard scorer that can be used as a dimension.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e353 ">Custom_Scorer_Dimensions_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e356 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>IF [Custom_Scorer_Semantic_Type_clc] = 'Dimension'
AND [AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag_Definition_Association3_Is_Active] = TRUE
AND [Is_Session_Scorer_Standard_clc] = FALSE
AND (
    [AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag_Definition2_Source_Type] = 'Predefined'
    OR
    (
        [AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag_Definition2_Source_Type] = 'OpenEnded'
        AND NOT ISNULL([AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag2_Value])
        AND [AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag2_Value] != 'NOT_SET'
    )
)
THEN [AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag_Definition2_Tag_Identifier] 
END</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e347 ">Custom Scorer Dimension Values</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e350 ">Shows a custom scorer dimension together with its recorded value.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e353 ">Custom_Scorer_Dimension_Values_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e356 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>IF NOT ISNULL([Custom_Scorer_Dimensions_clc]) THEN
    [Custom_Scorer_Dimensions_clc]+" : "+[AI_Agent_Session_Tag_Association_lv].[AI_Agent_Tag2_Value]
ELSE
 '--'
END</code></pre>
            </td>

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

## Message and Response Timing Fields

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small " summary="Dimension Formulas">
        <caption>Dimension Formulas</caption>
        <colgroup>
          <col style="width:23.076923076923077%">
          <col style="width:15.384615384615385%">
          <col style="width:30.76923076923077%">
          <col style="width:30.76923076923077%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d199015e646">Label</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d199015e649">CX Description</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d199015e652">Field Name</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d199015e655">Formula</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e646 ">Agent Interaction Duration</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e649 ">Shows the interaction duration in seconds, from start to end.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e652 ">Agent_Interaction_Latency_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e655 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>DATEDIFF('SECOND', [AI_Agent_Interaction].[Start_Timestamp], [AI_Agent_Interaction].[End_Timestamp])</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e646 ">Moment Duration</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e649 ">Shows the moment duration in seconds, from start to end.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e652 ">Moment_Duration_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e655 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>DATEDIFF('SECOND', [AI_Agent_Moment].[Start_Timestamp], [AI_Agent_Moment].[End_Timestamp])</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e646 ">Agent Response Start Timestamp</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e649 ">Shows when the agent starts responding in an interaction.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e652 ">Agent_Response_Timestamp_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e655 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>{ FIXED [AI_Agent_Interaction].[AI_Agent_Interaction_Id] :
    MAX(
      IF NOT [Is_User_clc] THEN
        IF [AI_Agent_Interaction_Message].[Message_Start_Timestamp]
             &lt;= [AI_Agent_Interaction_Message].[Message_Sent_Timestamp]
        THEN [AI_Agent_Interaction_Message].[Message_Start_Timestamp]
        ELSE [AI_Agent_Interaction_Message].[Message_Sent_Timestamp]
        END
      END
    ) }</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e646 ">Agent Response End Timestamp</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e649 ">Shows when the agent finishes responding in an interaction.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e652 ">Agent_Response_End_Timestamp_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e655 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>{ FIXED [AI_Agent_Interaction].[AI_Agent_Interaction_Id] :
    MAX(
      IF NOT [Is_User_clc] THEN
        IF [AI_Agent_Interaction_Message].[Message_End_Timestamp]
             &gt;= [AI_Agent_Interaction_Message].[Message_Sent_Timestamp]
        THEN [AI_Agent_Interaction_Message].[Message_End_Timestamp]
        ELSE [AI_Agent_Interaction_Message].[Message_Sent_Timestamp]
        END
      END
    ) }</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e646 ">User Message End Timestamp</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e649 ">Shows when the user message ends in an interaction.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e652 ">User_Turn_Timestamp_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e655 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>{ FIXED [AI_Agent_Interaction].[AI_Agent_Interaction_Id] :
    MAX(
      IF [Is_User_clc] THEN
        IF [AI_Agent_Interaction_Message].[Message_End_Timestamp]
             &gt;= [AI_Agent_Interaction_Message].[Message_Sent_Timestamp]
        THEN [AI_Agent_Interaction_Message].[Message_End_Timestamp]
        ELSE [AI_Agent_Interaction_Message].[Message_Sent_Timestamp]
        END
      END
    ) }</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e646 ">Agent Response Time in Seconds</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e649 ">Shows agent response latency in seconds.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e652 ">Response_Time_Seconds_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e655 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>[Time_To_First_Agent_Token_clc] / 1000</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e646 ">Is Agent Response Within 60s</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e649 ">Indicates whether the agent begins responding within 60 seconds.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e652 ">Agent_Response_Within_60s_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e655 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>IF [Response_Time_Seconds_clc] &gt;= 0 AND [Response_Time_Seconds_clc] &lt;= 60 THEN TRUE ELSE FALSE END</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e646 ">Agent Response Latency</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e649 ">For eligible turns after July 10, 2026, shows milliseconds from the user message end until the agent starts responding.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e652 ">Time_To_First_Agent_Token_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e655 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>IF [AI_Agent_Interaction].[Start_Timestamp] &gt; #2026-07-10 00:00:00# AND [AI_Agent_Interaction].[Ai_Agent_Interaction_Type] = 'TURN' AND [Does_Interaction_Include_Only_Populated_Messages_clc] AND [Total_User_Messages_Per_Interaction_clc] = [Total_Agent_Messages_Per_Interaction_clc] THEN DATEDIFF('MILLISECONDS', [User_Turn_Timestamp_clc], [Agent_Response_Timestamp_clc]) END</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e646 ">Agent Response Completion Latency</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e649 ">For eligible turns after July 10, 2026, shows milliseconds from the user message end until the agent finishes responding.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e652 ">Time_To_Last_Agent_Token_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e655 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>IF [AI_Agent_Interaction].[Start_Timestamp] &gt; #2026-07-10 00:00:00# AND [AI_Agent_Interaction].[Ai_Agent_Interaction_Type] = 'TURN' AND [Does_Interaction_Include_Only_Populated_Messages_clc] AND [Total_User_Messages_Per_Interaction_clc] = [Total_Agent_Messages_Per_Interaction_clc] THEN DATEDIFF('MILLISECONDS', [User_Turn_Timestamp_clc], [Agent_Response_End_Timestamp_clc]) END</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e646 ">Does Interaction Include Only Populated Messages</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e649 ">Indicates whether every message in the interaction has content.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e652 ">Does_Interaction_Include_Only_Populated_Messages_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e655 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>{ FIXED [AI_Agent_Interaction].[AI_Agent_Interaction_Id] : MIN(IF NOT ISNULL([AI_Agent_Interaction_Message].[Content]) AND [AI_Agent_Interaction_Message].[Content] &lt;&gt; '' THEN TRUE ELSE FALSE END) }</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e646 ">Total User Messages per Interaction</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e649 ">Counts user messages in the interaction.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e652 ">Total_User_Messages_Per_Interaction_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e655 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>{ FIXED [AI_Agent_Interaction].[AI_Agent_Interaction_Id] :
    COUNTD(
        IF [Is_User_clc]
        THEN [AI_Agent_Interaction_Message].[AI_Agent_Interaction_Message_Id]
        END
    )
}</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e646 ">Total Agent Messages per Interaction</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e649 ">Counts nonuser messages in the interaction.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e652 ">Total_Agent_Messages_Per_Interaction_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e655 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>{ FIXED [AI_Agent_Interaction].[AI_Agent_Interaction_Id] :
    COUNTD(
        IF NOT [Is_User_clc]
        THEN [AI_Agent_Interaction_Message].[AI_Agent_Interaction_Message_Id]
        END
    )
}</code></pre>
            </td>

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

## Agent, Action, and Connected Subagent Fields

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small " summary="Dimension Formulas">
        <caption>Dimension Formulas</caption>
        <colgroup>
          <col style="width:23.076923076923077%">
          <col style="width:15.384615384615385%">
          <col style="width:30.76923076923077%">
          <col style="width:30.76923076923077%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d199015e909">Label</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d199015e912">CX Description</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d199015e915">Field Name</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d199015e918">Formula</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e909 ">Agent Label</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e912 ">Shows the bot label when available; otherwise shows the agent API name.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e915 ">Agent_Label_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e918 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>IF 
    NOT ISNULL({ FIXED [AI_Agent_Session_Participant].[AI_Agent_Session_Participant_Id] : MAX([Bot].[Label]) }) 
THEN 
    { FIXED [AI_Agent_Session_Participant].[AI_Agent_Session_Participant_Id] : MAX([Bot].[Label]) }
ELSE 
    [AI_Agent_Session_Participant].[AI_Agent_Api_Name]
END</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e909 ">Subagent Label</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e912 ">Shows the related subagent label when available; otherwise shows the topic API name.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e915 ">Subagent_Label_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e918 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>IF 
    NOT ISNULL({ FIXED [AI_Agent_Interaction].[AI_Agent_Interaction_Id] : MAX([AI_Agent_Topic].[Master_Label]) })
THEN 
    { FIXED [AI_Agent_Interaction].[AI_Agent_Interaction_Id] : MAX([AI_Agent_Topic].[Master_Label]) }
ELSE 
    [AI_Agent_Interaction].[Topic_API_Name]
END</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e909 ">Action Label</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e912 ">For action steps, shows the action label when available; otherwise shows the step name.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e915 ">Tool_Label_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e918 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>IF [AI_Agent_Interaction_Step].[Ai_Agent_Interaction_Step_Type] = 'ACTION_STEP'
THEN
    IF NOT ISNULL({ FIXED [AI_Agent_Interaction_Step].[AI_Agent_Interaction_Step_Id] : MAX([AI_Agent_Action].[AI_Agent_Action_Id]) }) 
    THEN { FIXED [AI_Agent_Interaction_Step].[AI_Agent_Interaction_Step_Id] : MAX([AI_Agent_Action].[Label3]) }
    ELSE [AI_Agent_Interaction_Step].[Name]
    END
END</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e909 ">Connected Subagent Name</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e912 ">Shows the connected subagent name from the handoff step.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e915 ">Connected_Subagent_Name_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e918 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>IF [AI_Agent_Interaction_Step].[Ai_Agent_Interaction_Step_Type] = 'RELATED_AGENT_STEP' THEN REGEXP_EXTRACT([AI_Agent_Interaction_Step].[Attribute], 'related_agent_name":"([^"]*)') END</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e909 ">Connected Subagent Api Name</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e912 ">Shows the connected subagent API name from the handoff step.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e915 ">Connected_Subagent_Api_Name_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e918 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>IF [AI_Agent_Interaction_Step].[Ai_Agent_Interaction_Step_Type] = 'RELATED_AGENT_STEP' THEN REGEXP_EXTRACT([AI_Agent_Interaction_Step].[Attribute], 'related_agent_api_name":"([^"]*)') END</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e909 ">Connected Subagent Session Id</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e912 ">Shows the connected subagent session ID from the handoff step.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e915 ">Connected_Subagent_Session_Id_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e918 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>IF [AI_Agent_Interaction_Step].[Ai_Agent_Interaction_Step_Type] = 'RELATED_AGENT_STEP' THEN REGEXP_EXTRACT([AI_Agent_Interaction_Step].[Attribute], 'related_agent_session_id":"([^"]*)') END</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e909 ">Connected Subagent Interaction Id</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e912 ">Shows the connected subagent interaction ID from the handoff step.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e915 ">Connected_Subagent_Interaction_Id_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e918 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>IF [AI_Agent_Interaction_Step].[Ai_Agent_Interaction_Step_Type] = 'RELATED_AGENT_STEP' THEN REGEXP_EXTRACT([AI_Agent_Interaction_Step].[Attribute], 'related_agent_interaction_id":"([^"]*)') END</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e909 ">Orchestration Overhead</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e912 ">Shows handoff and orchestration time to the connected subagent, in milliseconds.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e915 ">Connected_Subagent_Orchestration_Duration_ms_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e918 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>IF [AI_Agent_Interaction_Step].[Ai_Agent_Interaction_Step_Type] = 'RELATED_AGENT_STEP' THEN INT(REGEXP_EXTRACT([AI_Agent_Interaction_Step].[Attribute], '"orchestration_latency_ms":(\d+)')) END</code></pre>
            </td>

          </tr>
          <tr class="">
            <td data-label="Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e909 ">Connected Subagent Execution Duration</td>

            <td data-label="CX Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e912 ">Shows connected-subagent execution time, in milliseconds.</td>

            <td data-label="Field Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e915 ">Connected_Subagent_Execution_Duration_ms_clc</td>

            <td data-label="Formula" class="slds-cell-wrap" style="vertical-align:top;" headers="d199015e918 ">
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>IF [AI_Agent_Interaction_Step].[Ai_Agent_Interaction_Step_Type] = 'RELATED_AGENT_STEP' THEN INT(REGEXP_EXTRACT([AI_Agent_Interaction_Step].[Attribute], '"sub_agent_execution_latency_ms":(\d+)')) END</code></pre>
            </td>

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