Showing a previous value and a new value in a report
I am trying to create a report that compares Account Addresses in Analytics database to the Real-Time reporting database. The report needs to show whose addresses changed in the last 24 hrs and includes a before and after listing of the Account's address change.
In CRM I have created a new field checkbox field that is updated by a workflow whenever an address changes. I have created a combined report for Account History in the Analytics Database and in Accounts for the Real-Time reporting.
My method is flawed b/c by the time the Analytics DB notices the checkbox it also notices the address change, so the only info I'm getting is the new address.