You need to sign in to do that
Don't have an account?
goabhigo
Superbadge - Create contact and hobby reports
I seem to have no clue what's wrong in the report which I created. As per the requirement - Summarize the report by Account Name, the contact’s Full Name, and show the Hobby Name." Here I do not understand Full Name, as in the report we only get First Name, Last Name.
The error says -
Challenge Not yet complete... here's what's wrong:
The 'Lightning Hobbies by Contact' report does not appear to have either the correct report type or (most likely) the correct columns.
I have summarized the report by Account Name, then by Last Name. Another column shown is Hobbies Name. The report filter is on Hobby Type (the bucket field) = Outdoor Activities and it is locked.
Does anyone know whats wrong?
The error says -
Challenge Not yet complete... here's what's wrong:
The 'Lightning Hobbies by Contact' report does not appear to have either the correct report type or (most likely) the correct columns.
I have summarized the report by Account Name, then by Last Name. Another column shown is Hobbies Name. The report filter is on Hobby Type (the bucket field) = Outdoor Activities and it is locked.
Does anyone know whats wrong?
I was getting the same error from last couple of days, after seeing this post I went around:
1 - removed the formula Full Name that i had created on Contact object.
2 - created a new Report Type with Account - Contact - Contact Hobbies as the object and ensured out of the box full name was present.
3 - re-created the same report (that we all created with other report type) using the new report type created as part of step2.
And it just worked.
Hope this helps.
All Answers
I tried again with other possibilities. I am getting new error now:
There was an unhandled exception. Please reference ID: YBWWCUCM. Error: ArgumentError. Message: bad argument (expected URI object or URI string)
Can anybody from Trailhead team please look into this? My First Ascent is long gone :(
--
Abhi
Challenge Not yet complete... here's what's wrong:
The 'Lightning Hobbies by Contact' report does not appear to have either the correct report type or (most likely) the correct columns.
I was getting the same error from last couple of days, after seeing this post I went around:
1 - removed the formula Full Name that i had created on Contact object.
2 - created a new Report Type with Account - Contact - Contact Hobbies as the object and ensured out of the box full name was present.
3 - re-created the same report (that we all created with other report type) using the new report type created as part of step2.
And it just worked.
Hope this helps.
what do u mean by this:
3 - re-created the same report (that we all created with other report type) using the new report type created as part of step2.
And it just worked.??
If you had created report with out of the box report type then create a similar report using custom report type.
In other words - we should create the report format using the custom report type.
Thanks
i have created custom report type, but still im getting error, report type is incorrecct.
I saw few updates on twitter that most of superbadges requirements and challenges have been changed or slightly modified (in terms of naming conventions and so on).... since we have completed; we aren't able to view those questions. Kindly recheck the conditions & requirements.
Thanks
I've cloned the 'Contacts by Hobby and Rating'-report for the report 'Hobbies by Contact', cleaned it up, and changed it to a summary report. I have added a filter, to select only the hobbies that equal 'Outdoor Activities' (= filter on the bucket field 'Hobby Type'), but in the summary results, I also get a few contacts that have a hobby which is not marked as an 'Outdoor Activity' in the bucket field. These contacts get the value '-' under 'Hobby Type' in the summary results.
Does anybody know what might be wrong?
Thanks for the help!
While you were bucketing for Hobby Type - did you ensure that you choose the option as shown, if so we shouldn't see "-" in the report.
Hope this helps..
Hope this helps!
Hi Ajay,
Yes, I did select 'Show unbucketed values as 'Other''.
Just to be sure, I've also deleted the bucket and made a new one, but that doesn't help either...
Could you re-confirm the error message and report screenshot pls.
Hi Ajay,
I don't get an error message. I just see in my report contact that I shouldn't see:
Summary results:
Report:
Bucket field:
Thanks for the help!!
i am getting this error message. Can anyone post their contact by hobby and rating report.
.
I haven't completed the 2nd challenge, but I believe the custom Report Type shoud look like this:
And the Contact by Hobby and Rating report should look like this:
Good luck!
I think i have done the same procedure but stll getting error msg.
Hi Bijendra,
The only difference I see between our reports is that I've added a cross object filter, but I don't know if that could be the cause of your error message...
If you've used the same custom report type for all the 3 reports, I don't know at this point what the problem could be. Does anybody else have a suggestion?
For which object you have created Hobby Type field for this step either 'Account' or 'Contact and Hobbies' ??
I tried but still same error. Can you tell me what are the fields you have created on account and contact and Contact with hobbies object for this challenge, and if possible please share one screen shot for your report.
I hope this helps Bijendra.
thanks for your reply
I tried, now its really testing my patience.
Can you tell me what are the field with data type you have created on account,contact, hobbies and contacthobby object.
Just a remark Bijendra, due to another issue I have not checked the challenge at this moment.
Finally i completed this step.
I had not imported data in account object correctly. Like every contacthobby is related with contact and every contact is related with account. So, make sure you have data in every object.
If you still facing any problem just let me know the error which you are getting.
Thank you for the response, I think my data is in correctly - I passed step 1 (import data). I am getting the below error message:
See below report:
Any help would be appreciated!
@Louise
It should look like this:
My Report looks like this:
With the setup like this:
I cannot see whats wrong at all!
The dashboards all passed ok.
I have checked the data, and relationships between objects.
I have had to re-create the report a few times, and although the Name of the report is "Lightning Hobbies by Contact", the Report Unique Name won't allow me to use that again so it is "Lightning_Hobbies_by_Contact3" or I get this:
I have been looking at this for 3 days now!
Any help would be greatly appreciated.
Any other ideas?
It mentions the columns.....
There are only 3 in the report:
Account Name (From Account Object)
Full Name (From Contact Object)
Hobby: Hobbies Name (From Contact Hobbies Object)
I also tried with Contact:Full Name from the Contact Hobbies Object just in case that was the issue.
I'm stuck!
What does it look like in Lightning?
I grouped by Account then contact then had the Hobby Name as a column.......Isn't this what was asked?
Changed mine now....
Still same Error!
Just cannot work it out.
Report type is right.
Report looks like yours.
Same error.
Completely stumped
I did see on one forum that SF do a DB cleanup every weekend, and that it may resolve the issue after the next cleanup, but I'm not sure if that is correct.
I am struggling with the same issue - my report is exactly the same as above, and it allowed me to pass the dashboard part using the report. Can you explain what you did to complete the step? Thank you!
Getting This Message!!
Challenge Not yet complete... here's what's wrong:
The 'Contacts by Hobby and Rating' report is not configured correctly.
5
Create contact and hobby reports
Create the three hobby-related custom reports as detailed in the Business Requirements section above. Use the same custom Report Type as the basis of these custom reports. Set the Accounts object as the top level of the Report Type.
Please help me to pass this challange!!
Thank You!
Hobby Type
rating
Acoount Name
Hobby: Hobby Name
Full Name
Challenge Not yet complete... here's what's wrong:
The 'Lightning Hobbies by Contact' report does not appear to have a locked filter.
What am I doing wrong here???
I am getting the error message: The 'Lightning Hobbies by Contact' report does not appear to have either the correct report type or (most likely) the correct columns.
I have checked my columns and think the problem is that I have created a custom field for contact: full name. I did this because the name field for contacts is not available on the report builder (and there is no out-of-the box field called full name on the contact object).
I've read through the thread above and cannot see an answer to this - other than a number of people have simply said - use the out-of-the box field. However, I'm struggling to do this as it does not seem to be available - can anyone help?
Many thanks!!
Theodore
Kindly try these options:
2 - created a new Report Type with Account - Contact - Contact Hobbies as the object and ensured out of the box full name is present.
3 - re-created the same report (that we all created with other report type) using the new report type created as part of step2.
And it just worked.
Thank you - yes - I saw this earlier but was unaware of the custom report type builder so misunderstood your meaning. Have since worked this out and created a report!
Quick tip if you are new to lightning experience as I am. After fixing the above (thanks again Ajay!) I got another issue - The 'Lightning Hobbies by Contact' report does not appear to have a locked filter.
The issue was that in lightning experience you get the option to lock a filter (https://help.salesforce.com/apex/HTViewHelpDoc?id=reports_builder_filtering.htm&language=en_US)which is not possible in Classic.
Does this fail the check?
What is happening here?
Thanks,
Shawn
Shawn,
Your issue with the "-" has to do with filters. Your report is including contacts without Contact Hobby child objects (Contacts without Hobbies). As a result, the Contact Hobby field is blank for those contacts, and currently, you cannot include blank/null values in buckets in Salesforce.
To avoid this - you must first make sure that your report type is Accounts with Contacts with or without Contact Hobbies, and second, make sure that you apply a Cross Filter to the report to ensure that only Contacts with Contact Hobbies are included.
Thanks,
Loran
Thank you,
Loran
I have an issue with loading the contact_hobbies data.
Getting an error message Acton Mercado,"Camping","Contact: id value of incorrect type: Acton Mercado".
I am using dataloader.io and the unmanaged installed data model that comes along with the superbadge.
When I am dropping the M-D Relationship and make them custom fields, I can load the data. However, I guess to pass the challenges the M-D relationship should be there.
Thanks,
Ron
IN CLASSIC: When you are adding the filter to the report in report builder there is a little checkbox where you can lock the filter.
IN LIGHTNING: When you switch back you will see the locked filter
Hope this helps save some of the frustration I went through! :)
Did you ever figure out the problems you were having with the Lightning Hobbies by Contact report? I'm getting the exact same issue and I did delete one version so API name has numbers on end.
Challenge Not yet complete... here's what's wrong:
The 'Lightning Hobbies by Contact' report does not appear to have either the correct report type or (most likely) the correct columns.
Report setup:
Report in Lightning Experience:
I´ve created an extra field in contacts to generate Full Name:
Then created the report on Contacts & Accounts.Made the bucket for Hobby Typed, filtered and locked for Outdoor Activity. Grouped by Account Name and Full Name, leaving Hobby Type and Hobbies Name as columns. I´ve also tried using the name "Contact Full Name". not adding Hobby Type as column, moving the report to another folder. Nothing works.
Check the locked box on the Hobby Type filter.
The 'Lightning Hobbies by Contact' report does not appear to have a locked filter." even tho the filter - Hobby Type equals "Outdoor Activities" IS locked? - Even shows that it has been locked when running the report in lighting
Challenge Not yet complete... here's what's wrong:
The 'Contacts by Hobby and Rating' report is not configured correctly.
I can not understand where I was wrong !!
I was also facing the same issue for the 'Contacts by Hobbies and Ratings' and tried all the above solutions but failed to complete because I had two reports with the same label (API names were different but still having the issue ). So please make sure that you only have one report with the label as 'Contacts by Hobbies and Ratings' and try again. It may help.
However, Contact Hobbies is not showing up as an option for me:
I can't figure out how to fix this. Can anyone help?
Arts and Crafts
Extreme Sports
Games
Copy and Paste these Bucket Field options exactly.
I got the 'Contacts by Hobby and Rating' report is not configured correctly because I put: Arts & Crafts instead of Arts and Crafts
Thanks for your post, but this doesn't help much. The third, "green" option - Contact Hobbies, is not showing up on my picklist. How can I get this to show up?
Thanks,
Ayelet
I was struggling with this as well. In my first attempt to complete the [Contacts by Hobby and Rating] report I had not use "Account" as the top object as stated in the Superbadge details. "Note: Create a custom report type to form the basis of all three reports, with Accounts as the top object."
I deleted the report and recreated it by selecting "New Report... --> Accounts & Contacts --> Contacts with Contactd Hobbies and Hobbies
I then recreated the report putting every hobby in one of the four catergoires Outdoor Activities
Arts and Crafts
Extreme Sports
Games
I saved the report and checked the challenge. It failed with message "'Contacts by Hobby and Rating' report is not configured correctly"
I then went back in to the report and removed one of the hobbies from a bucket, so that I ended up with an "Other" Hobby Type in the report.
I rechecked the challenge and it passed.
I hope this helps someone!! Good luck