Skip to main content

Hi !  

 

 I have an issue in completing the App Customization Specialist Superbadge :   Even though I do the correct manipulation I still get the error message following : The 'My Top Volunteer Organizations' report is not sorting the correct direction.     

 

What I do is create the report from the report type "Users with Volunteer Shift Worker Records", then I name it "My Top Volunteer Organizations" and place it in the folder "Volunteer Reports".   

 

Then I set the date filter to all dates for Created Dates in Volunteer Shift Worker Records, and set the filters for Confirmed or Completed Status, and IsShiftVolunter to true.   

 

After that I had the column ShiftHours, then I group rows by Volunteer Organization. After that I sort the column By Sum of Shift Hours (under Vol Org drop down arrow), and sort the Vol Org in Descending Order.     

 

Still, it didn't work, I tried all the sorting orders, even for the Shift Hours column itself.     

 

I don't know how to pass this section and make the verification move on to the next report.   

Could you help me please ? #Trailhead Challenges

5 respostas
  1. 28 de out. de 2021, 10:26

    Thanks for the help, it worked thanks to Jonathan Davis 33's comment : 

     

    To fix this, I deleted "Volunteer Organization" in all three of the "Volunteer Job" "Volunteer Shift" and "Volunteer Shift Worker" objects, then remake them as formulas with the below formulas:

    • Volunteer Job: Volunteer_Activity__r.Volunteer_Organization__r.Name
    • Volunteer Shift: Volunteer_Job__r.Volunteer_Organization__c
    • Volunteer Shift Worker: Volunteer_Shift__r.Volunteer_Organization__c