Asset Audit pie chart and summary card values show different counts on sn_hamp_asset_audit recordSummary<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } On a Hardware Asset Management (HAMP) Asset Audit record (sn_hamp_asset_audit), the pie chart "Asset Audit Results by Asset Status" displays different totals than the summary card fields (Scanned and expected, Scanned and not expected, Expected and not found, New). The pie chart typically shows LOWER values than the summary cards. The discrepancy appears after the audit scan has completed and persists permanently.Example: Summary cards: Expected=111, Not Expected=29, Not Found=55, New=0 (Total=195) Pie chart: Expected=109, Not Expected=29, Not Found=54 (Total=192)Cause: The summary card values and the pie chart use different data retrieval strategies: [-] Summary cards: Read from precalculated integer fields on the sn_hamp_asset_audit record. These values are calculated ONCE at the end of the audit scan by the action item "Audit Scan" on sn_hamp_m2m_audit_asset. After the scan completes, these fields are never recalculated. https://<instance-name>.service-now.com/sys_sg_write_back_action_item.do?sys_id=6741f2b501521110fa9b7e90b0a15329at line 288 [-] Pie chart: Runs a LIVE COUNT query against sn_hamp_m2m_audit_asset grouped by audit_status on every form load https://<instance-name>.service-now.com/sys_report.do?sys_id=049544d651130010fa9bb8302cc1b43fThe discrepancy occurs when sn_hamp_m2m_audit_asset records are modified AFTER the scan completes. The most common cause is like asset deletion: the asset field on sn_hamp_m2m_audit_asset has reference_cascade_rule="delete", so deleting an alm_asset record (e.g., retiring or decommissioning an asset) automatically removes the corresponding m2m record. The pie chart reflects this removal immediately, but the summary card fields remain at their original populated values.