+ Start a Discussion
Brian KesslerBrian Kessler 

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

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:User-added image


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?)
Best Answer chosen by Brian Kessler
Brian KesslerBrian Kessler
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.

All Answers

NagendraNagendra (Salesforce Developers) 
Hi Brian,

Sorry for this issue you are encountering.

May I suggest you please check with below link from the success community with a similar discussion which might help you further. Please let us know if this helps.

Kindly mark this as solved if the reply was helpful.

Thanks,
Nagendra
Brian KesslerBrian Kessler
Hi @Nagendra,

While the success page looks as if it should be helpful, either I'm not understanding it properly or it isn't the problem (or at least not the entire problem).

Originally was sorting by "Sum of Shift Hours" (descending) as the requirement reads "Sort high to low by hours", so this would make sense.

@Sabrina Chen declaired "sorting THE summed field is not the way to go".
She went on to suggest 'It should be done from the list of available fields under the "organization"', but I'm not really clear what that means.

The only interaction I can have with the list of available fields is to drag them onto the record.  I can't sort from that list.

On "Volunteer Organization" on the report, I have only three possible fields I can sort by, only one of which makes sense for the requirement but has been declared "not the way to go".

So I permeated through all the other group sorting options, regardless that they all would seem erronious:
- Volunteer Organization Ascending
- Volunteer Organization Descending
- Sum of Shift Hours Ascending (just to be thorough!)
- Record Count Ascending
- Record Count Descending.

Not surprisingly, none of these were effective to fix the problem.

I revealed the details to remove the seemingly ignored sort by hours decending, which I had implemented before hiding the details and sorting by the sum of shift hours.  I then hid the details and again tried sorting again on each of the group sorting options.

None of this fixed the problem either.  :-(
Kumara Murali 42Kumara Murali 42
Hi @Brian,
Below is my report. You should also summarize Shift Hours by sumUser-added image
Brian KesslerBrian Kessler
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.
This was selected as the best answer
Thejas P 13Thejas P 13
I'm not able to complete challenge#4.
I have created the report "My Top Volunteer Organizations" & saved it in "volunteer reports" folder, even then I'm getting this error.

Challenge Not yet complete... here's what's wrong: 
Couldn’t find the report 'My Top Volunteer Organizations'.

Also, my "Shift hours" record count is "ZERO" because of no records matching the filter criteria.
Pls help me to overcome this error.

User-added image Thanks in Advance...
 
Darrin RobertsDarrin Roberts
I am having the same problem and have tried everything. I have deleted all dashboards, reports and custom report types and recreated. I am not sure this challenge should require one to examine metadata, which I believe is beyond the scope of what is expected. It seems that it would have flagged us early on, had we created something that would cause an extremely basic and elementary report to fail the test, even though it produces the desired results.

Has anyone been able to solve this issue without having to do what Brian is suggesting?
岳晃 大岩岳晃 大岩
私も同じ問題で詰まりました。このスレッドに対する回答と思われるものが見つかったので記録として残しておきます。
@Brian Kesslerはレポートタイプを作成するとき、[Volunteer Shift Worker (Last Modified By)]で作ったのではないでしょうか?
[Volunteer Shift Worker]でレポートタイプを作成しなかったことが原因と私は推測します。
@Darrin Robertsが言うとおり、メタデータにまで手を加える必要はないはずです。

I got stuck with the same problem. I found an answer for this thread, so I will leave it as a record.
When @Brian Kessler creates a report type, isn't it created by [Volunteer Shift Worker (Last Modified By)]?
I guess that I did not create a report type in the Volunteer Shift Worker.
As @Darrin Roberts says, you shouldn't have to deal with metadata.User-added image
Akash Pandey 25Akash Pandey 25
HI @Brian Kessler, @Darrin Roberts @岳晃 大岩, Kumara Murali

I have been stuck on this step for so many days now! Can someone please help? I have tried all combinations as well, nothing seems to work
Here is my latest iteration of the report-
User-added image

Can someone tell what is wrong here?
harshala guptaharshala gupta
Hi @Nagendra,
I got stuck in app customization superbadge where i cannot get only volunteer shift worker.can you pleae guide me.
User-added imageUser-added imageUser-added image