However, I have summarized the shift hours and the report is sorted by Sum of Shift Hours, as seen below:Report Builder:Challenge Not yet complete... here's what's wrong:
The 'My Top Volunteer Organizations' report is not sorting by the correct field.
10 respostas
With the help of @Musunuru Surekha who shared his metadata with me, I was able to discover the problem. When I created the report type, somehow the report type was associated with Volunteer_Shift_Worker__c$LastModifiedById instead of User.Volunteer_Shift_Workers__r Thus all my reports were referencing the right fields but of the wrong related records. Making the correction was actually a little tricky.
- Download all your metadata (or at least those for Reports, Dashboards, Flexpages, and Tabs).
- Put these somewhere safe.
- To delete your reports, delete any related dashboards, flexpages, and tabs from your org.
- Delete and recreate your record type.
- You could modify the record type, but then you need to manually add all the fields for Object B.
- You can actually modify the record type without deleting the reports, but then the reports seem to get hopeless corrupted.
- You could modify the record type, but then you need to manually add all the fields for Object B.
- On your local machine, using your favourite text editor (or whatever tool you otherwise find convienent), replace all the references to the wrong object record (e.g. Volunteer_Shift_Worker__c$LastModifiedById) with references to the right object record (e.g. User.Volunteer_Shift_Workers__r).
- Upload your revised metadata.
- This might take a couple iterations because of dependencies.