Skip to main content
Hi,

I'm currently working on the App Customization Specialist Lightning Superbadge.

I'm stuck on Challenge 4 with the reported error of:

 

Challenge Not yet complete... here's what's wrong:

The 'My Top Volunteer Organizations' report is not sorting by the correct field.

However, I have summarized the shift hours and the report is sorted by Sum of Shift Hours, as seen below:

Report Builder:App Customization Specialist, Challenge 4: What is wrong with my report sorting?

Report:User-added image

Could this error description be incorrect and misleading?

If so, what else might be wrong on this report?

(Am I even correct to believe it is a problem with this report?)
10 件の回答
  1. 2018年5月4日 14:19
    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.

    1. Download all your metadata (or at least those for Reports, Dashboards, Flexpages, and Tabs).
    2. Put these somewhere safe.
    3. To delete your reports, delete any related dashboards, flexpages, and tabs from your org.
    4. Delete and recreate your record type.

      1. You could modify the record type, but then you need to manually add all the fields for Object B.

        1. You can actually modify the record type without deleting the reports, but then the reports seem to get hopeless corrupted.
    5. 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).
    6. Upload your revised metadata.

      1. This might take a couple iterations because of dependencies.