I've managed to set up a field history report, which works great.
Unfortunately it shows me all changes within a certain period. But if there are several changes within the same opportunity I'd like to have shown in my report only the latest change and not all changes within my "track period". Can you help me how?
Thanks,
Philipp
답변 13개
If you only want one entry per change then the custom date field on the Opportunity is the only way to go.
If you are using the history object it is not possible, it will return all the record that meet the criteria, not just the latest record.
with the power of one it will tell you how many opportunities have changed Close Date in Last 14 Days but the only drwaback with this is the report will include multiple instances of the same record if the close date is changed multiple times in last 14 days for a record.
