Search report results for contacts.any_phone_raw vs. any_phone
SummaryLooking to understand why the rows analyzed are different for the two fields
Why do the fields have a different number of analyzed rows if they're both searching the phone fields? Report definition for the original report is attached.
In April 2020 we imported around a half million contact records from product registration to assist servicing warranty inquires. In May 2020 we upgraded from 19C to 20A.
After the upgrade our "Find a Contact" report could not be processed because it exceeds the query size limitation. Agents are searching by 10 digit phone number in the report filter field contacts.any_phone_raw