Skip to main content

Lightning Experience Reports & Dashboards Specialist Superbadge - 5-6


I might complain about my brother sometimes...especially how he takes up so much of mom's time...but I've decided that he really is a nifty fellow.  Why the change of heart?  My brother has started to play with me!  He laughs when I poke his nose and tries to take toys out of my hand.  Right now he' taking a nap....so I'm off to edit some reports!

 Executive Report Tips:
SolarBot Loyalty Revenue
This report is tricky, but I don't want to give away the solution!  Something that helped was saving the report frequently.  When I made mistakes, I simply reverted to the last saved version. 

Confused? Take a break, grab a snack, and watch this video.  If you are short on time, start around the 20 minute mark.  Still stuck?  Leave a comment for the Trailhead Baby!


 Report Modifications:
Sales
Two words: Filter Logic
Support
If you get this error...try stacking to 100% and make sure that you have a "horizontal" style chart.



R&D
Getting this error message?  Here's a few hints:
1) Use the chart style "column"
2) Check out the graphic below - It should help you get started! 





Comments

  1. UnknownSeptember 18, 2018 at 7:56 PM

    I am stick on Step 6. It cannot not find my solarbot lightning record type page. Any tips here?

    ReplyDelete
    Replies
    1. Trailhead BabySeptember 19, 2018 at 8:32 AM

      Double check the spelling- The challenge is likely looking for the page's name to be exactly what is stated in the instructions. Also, make sure that you created the correct type of lightnting page & placed the component on the page. Still stuck? Share some details of what you have.

      Delete
  2. JoshJanuary 23, 2019 at 1:06 PM

    Hi Trailhead Baby - I'm stuck on Step 6 as well, saying that it can't find my page. I've created the page and assigned it as the app default (and the default for everything else under the sun). And I copy/pasted the name. Any guidance you could provide would be a-mazing! Thanks!

    ReplyDelete
    Replies
    1. Trailhead BabyJanuary 23, 2019 at 1:42 PM

      On the page, is the developer name this: SolarBot_Status_Page_With_Chart ?
      Could you share a few more details?

      Delete
    2. UnknownMay 5, 2019 at 6:01 PM

      I am having the same issue. My page looks exactly like screenshots of passing pages, but Trailhead says "We can't find a page with the name 'SolarBot Status Page with Chart'"

      Delete
    3. Trailhead BabyMay 6, 2019 at 9:19 AM


      Did you check the developer name of the chart? If you created/re-created it a few times, it may have the wrong name since the API/developer names must be unique.

      Also- Did you activate the page?

      Delete
    4. AnonymousJuly 22, 2022 at 1:53 PM

      For anyone struggling with this as I did in 2022, make sure that the object you select is "SolarBot" and not "SolarBot Status".

      Delete
    5. AnonymousJune 29, 2023 at 5:22 AM

      Thank you Anonymous for telling me to go to the "SolarBot" Object. I love you!

      Delete
    6. AnonymousDecember 30, 2023 at 3:12 AM

      same issues with me Challenge Not yet complete... here's what's wrong:
      We can't find a page with the name 'SolarBot Status Page With Chart'.

      Delete
  3. IanMarch 25, 2019 at 11:28 AM

    Hi Trailhead Baby - I'm stuck on Step 6 wherein I need to create a page for the SolarBot Status Averages.This is the error that I'm getting "The 'SolarBot Status Page With Chart' Lightning app doesn't use the chart from the 'SolarBot Status Averages' report with data specific to the SolarBot." Thanks!

    ReplyDelete
    Replies
    1. Trailhead BabyMarch 26, 2019 at 5:21 AM

      Could you share some details of your report? On the lighting page, are you filtering the report?

      Delete
  4. inhoodywetrustMay 9, 2019 at 2:09 PM

    Hey I'm stuck on 5 and it's telling the incorrect account names are on the report. My concern is that NEXT 45 Days relative fliter, as I was working on this a while back but now all the warranty expirations are past. Did I screw myself by putting this down and coming back to it later?

    ReplyDelete
    Replies
    1. Trailhead BabyMay 10, 2019 at 9:54 AM

      The data shouldn't matter... the challenge "checking" mechanism typically only looks at configuration- not at the data itself. I'm a little confused though- Are you on step 5- the executive report? Could you share the exact error message?

      Delete
    2. inhoodywetrustMay 13, 2019 at 3:45 PM

      Got it figured out. i was using the relative date wrong

      Delete
    3. Trailhead BabyMay 14, 2019 at 5:15 AM

      Glad to hear!!

      Delete
    4. AnonymousApril 12, 2023 at 8:01 AM

      I had to make sure one was grouped in the rows and one in the column sections of the report.

      Delete
  5. AnonymousJune 15, 2019 at 10:39 AM

    Thank you for this blog, it has been an invaluable resource.

    I am stuck on Challenge # 6.
    Here is the error -
    Challenge Not yet complete... here's what's wrong:
    We can’t find the additional analysis by model being performed on the 'Temperature to kWh Research' report. Remember that you can organize data horizontally and vertically at the same time.

    I cannot find a field called SolarBot Model.

    Report / Chart as follows:
    Group Rows: Temperature Range Bucket
    Group Columns: Cannot locate a field called SolarBot Model - only SolarBot Name?
    Columns: # Kilowatt Hours (Average), # Panel Temperature (Average)

    Chart is currently horizontal bar, but I have tried various combinations.

    Any guidance that you can provide is greatly appreciated.

    ReplyDelete
    Replies
    1. Trailhead BabyJune 17, 2019 at 9:04 AM

      What custom report type are you using? The "SolarBot Model" is a field on the SolarBot object. You would need a custom report type to have SolarBots and Status information. My guess is that there is a error with the report type if the field is missing.

      Delete
    2. AnonymousJune 18, 2019 at 9:27 PM

      Perfect, thank you.

      Revisited the SolarBots and Status Data report type. Added SolarBot Model back in to the SolarBot Status field layout properties and passed the challenge.

      Onto challenge #7 with enthusiasm renewed, thank you so much.

      Delete
  6. AnonymousAugust 8, 2019 at 9:20 AM

    Hello!

    Thank you so much for this blog!!! I was wondering if you could give me some guidance on an area of Challenge 6 that isnt working out for me. I think I am missing something simple. When I go to add the Report Chart Component to the Lightning Page, I have no options under the Filter By dropdown. I know that I should be able to filter by the SolarBot ID but it wont show up there. Any suggestions? Thanks in advance!

    ReplyDelete
    Replies
    1. Trailhead BabyAugust 8, 2019 at 10:21 AM

      On the SolarBot Status Averages report on the "SolarBot Status Page With Chart" page? The option should be there in the lighthing app builder on the far right after you drop the report in. See it? If not, I'm happy to look at a screenshot (rebecca@capstorm.com)

      Delete
    2. AnonymousAugust 13, 2019 at 9:48 AM

      Thank you so much for your offer of assistance! I just figured out where I made the error. I was creating an app page instead of a record page in the Lightning App builder! Have a wonderful day!

      Delete
  7. AnonymousOctober 19, 2019 at 3:08 PM

    Working on this right now. Your below response to one of the questions....how do you get around this? If it needs a unique name. I have tried a few times, and deleted all pages, but it won't take the standard developer name anymore? Any advice?

    Did you check the developer name of the chart? If you created/re-created it a few times, it may have the wrong name since the API/developer names must be unique.

    Also- Did you activate the page?

    ReplyDelete
    Replies
    1. Trailhead BabyOctober 21, 2019 at 5:38 AM

      Developer name... You have to delete the chart/report/etc, empty the recycle bin, then wait 24 hours. After that, the name can be reused. (It's not pretty...but so it goes)

      Delete
  8. AnonymousNovember 18, 2019 at 11:51 PM

    Hi ,

    Trailhead Baby,

    I am stuck in step 6 of Lightning Experience Reports & Dashboards Specialist. I am getting below error:
    Challenge Not yet complete... here's what's wrong:
    We can't find a page with the name 'SolarBot Status Page With Chart'.

    I have Selected
    1. record page in lightning app builder and
    2. selected object solarbot,
    3.used report SolarBot Status Averages,
    4.also Activated it
    Assigned it to Solarbot App,

    Still i am getting this error. I am trying on it from past 2 days.

    Could you please help.

    ReplyDelete
    Replies
    1. Trailhead BabyNovember 20, 2019 at 2:43 PM

      I would start by double checking the name of the page- Not the name you gave but the unique Salesforce API name. It should be SolarBot_Status_Page_With_Chart


      Is the page activated as org default?

      Delete
    2. kthomsonJuly 22, 2021 at 3:31 PM

      What can I do if it won't let me change the unique Salesforce API name?

      Delete
    3. Anna WatersSeptember 15, 2021 at 11:24 AM

      I have the same error and my API name is SolarBot_Status_Page_With_Chart so it's not that.

      Delete
    4. UnknownOctober 15, 2021 at 2:42 AM

      Hello Trailhead baby,
      I hope you are great, I have the same issue and I am super stuck. I posted here as well. https://trailhead.salesforce.com/en/content/learn/superbadges/superbadge-lex-rd
      Basically the page seems to be there and named correctly (AP)/Dev name), any more pointers please ?

      Delete
  9. dheerajbDecember 16, 2019 at 2:05 PM

    Hi Trailhead Baby,

    I'm in challenge 6 and facing error "We can't find a graph displaying the requested data on the 'SolarBot Status Averages' report."
    and also I'm not able to find the filter 'SolarBot ID' in the page. Kindly help me with this.
    Thanks in advance

    ReplyDelete
    Replies
    1. Trailhead BabyDecember 17, 2019 at 9:21 AM

      Did you add a chart to the report? You do not need the solar bot ID column- but there is a field that identifies the status of the solar bot.

      Delete
  10. UnknownDecember 29, 2019 at 2:20 AM

    hi Traihead Baby,

    I'm stuck on challenge 5!!!! the error says:-
    Challenge Not yet complete... here's what's wrong:
    We can’t find a new column 'Adjusted Expected Revenue' on the 'SolarBot Loyalty Revenue' report that meets the requirements.
    the formulla i used: IF(Account.Number_of_SolarBots__c:SUM > 0, EXP_AMOUNT:SUM * 1.1, EXP_AMOUNT:SUM)
    the format is currency and no filters are been used.Applied the formulla to all summary levels.Can you please guide me where am i going wrong?

    ReplyDelete
    Replies
    1. Trailhead BabyJanuary 2, 2020 at 8:30 AM

      Formula is incorrect in syntax- it is missing a "(" and ")" around part of the forumla.

      Delete
    2. AnonymousAugust 21, 2022 at 3:32 PM

      How is there an AND () condition missing? There is simply an evaluation of IF the account has any SolarBots records associated via the rollup summary formula.

      Delete
  11. UnknownJanuary 7, 2020 at 5:31 PM

    Hi Trailhead Baby,

    I'm in challenge 6 pretty much all day and it's giving me the error "We can't find a graph displaying the requested data on the 'SolarBot Status Averages' report. I have been constantly saving my information. Here is what I have so far: Chart Title, X-Axis = Temp. Range & Status Date, Y-Axis = Average Panel Temp.
    Thank you for any help you can give.

    ReplyDelete
  12. AnonymousJuly 4, 2020 at 1:14 AM

    I am working on the first dashboard of challenge 3 and I get the error: Challenge Not yet complete... here's what's wrong:
    An incorrect source report is assigned to the 'Account Distribution' component.
    The report it is referring to is the Accounts by Market report. I think that one is correct because I check each challenge as I go along and the report itself didn't get an error message.

    ReplyDelete
    Replies
    1. Trailhead BabyJuly 6, 2020 at 9:49 AM

      This superbadge only has 1 dashboard and no "accounts by market" report. So... I'm a little confused. Which superbadge are you working on? Could you post to the blog page related to the superbadge?

      Delete
  13. BreakingNewsReportAugust 3, 2020 at 10:21 AM

    Step 2
    #Number of SolarBots int visible inside column

    ReplyDelete
  14. AnonymousDecember 5, 2020 at 9:48 PM

    I am on Lightning Experience Reports & Dashboards Specialist step 6. Error I am getting: We can't find data organized by week on the 'SolarBot Status Averages' report.
    I changed Status Date to Group by Calendar week. I changed Avg Percent Obscured, Average Panel temp and Average Kilowatt Hours to Avg and got rid of Sum. Turned off the row counts, detail rows, subtotals and grand total. Made a line chart with Avg Panel temp on x axis and Two lines avg Kilowatt hours and avg Panel temp on w axis.

    ReplyDelete
    Replies
    1. Trailhead BabyDecember 15, 2020 at 10:40 AM

      Did you solve this?

      Delete
    2. AnonymousAugust 23, 2022 at 11:28 AM

      bro pls solve this issue from 2 days i am stucked at this point

      Delete
  15. UnknownFebruary 3, 2021 at 2:50 PM

    Hi Trailhead Baby,
    I'm stuck on Lightning Experience Reports & Dashboards Specialist step 6. I'm receiving error "We can't find a graph displaying the requested data on the 'SolarBot Status Averages' report."

    I changed Status Date to Group by Calendar week. I checked that Average Panel Temperature and Average Kilowatt Hours was spelled as listed in the challenge. Double checked the report title is spelled correctly. I have a line chart with the Status Date on X-axis. The Y-Axis is Average Panel Temperature. I used +measure to add Average Kilowatt Hours. Both lines are showing, but the y-axis measurement label lists the Avg Panel Temp. Turned off the row counts, detail rows, subtotals and grand total. I've saved multiple times after various changes. I've moved the legend to different spots. I'm not sure what else to try. Thanks for your help!

    ReplyDelete
    Replies
    1. AchimSeptember 29, 2021 at 9:45 AM

      Same issue here. Have you ever received a suitable answer or resolved it otherwise?

      Delete
    2. UnknownNovember 22, 2021 at 6:16 PM

      Exactly the same for me. Any luck?

      Delete
    3. AnonymousJanuary 20, 2024 at 6:48 AM

      I also get same problem and try to solve or checked as per comments given but it still show same error.

      Delete
    4. AnonymousJanuary 20, 2024 at 6:49 AM

      Anyone have solution please give

      Delete
  16. LavanyaFebruary 4, 2022 at 8:18 PM

    Thanks for your information. very good article.
    Salesforce CPQ Course
    Salesforce CPQ Learning Path

    ReplyDelete
  17. LavanyaFebruary 12, 2022 at 9:31 AM

    your valuable information and time. Please keep updating.
    Learn Salesforce CPQ
    Salesforce CPQ Online Training

    ReplyDelete
  18. patJuly 27, 2022 at 10:53 PM

    Hi everyone, I'm stuck on challenge 8 for the report Superbadge and cannot find my error. I keep getting: Challenge Not yet complete... here's what's wrong:
    The 'Opportunity Overview' component doesn't display data in the correct format or displays incorrect fields.
    I'm showing the correct columns, the colors are set to be gray/blue at 20,000 and 50,000... sorted by stage/ascending... HELP?

    ReplyDelete
  19. AnonymousSeptember 1, 2022 at 5:59 AM

    Challenge Not yet complete... here's what's wrong:
    We can't find the correct access configuration for the SolarBot Support Reports folder.

    ReplyDelete
  20. AnonymousSeptember 1, 2022 at 5:59 AM

    pls help me to solve

    ReplyDelete
  21. AnonymousOctober 30, 2022 at 10:27 PM

    The 'SolarBot Pipeline by Stage' component doesn't display data in the correct format or doesn't show both side-by-side bars correctly. Or the dashboard needs to be refreshed.

    ReplyDelete
  22. AnonymousNovember 10, 2022 at 2:04 AM

    Hi sir please solve my problem
    The 'SolarBot Status Page With Chart' Lightning app doesn't use the chart from the 'SolarBot Status Averages' report with data specific to the SolarBot.

    ReplyDelete
  23. AnonymousNovember 28, 2022 at 2:54 PM

    We can't find a page with the name 'SolarBot Status Page With Chart'.

    ReplyDelete
  24. Mayank TalapdaDecember 28, 2022 at 8:57 PM

    You have written very well here, I read it, I have also written something like yours, you would love to read it. click here

    ReplyDelete
  25. AnonymousMarch 21, 2023 at 11:56 AM

    Hello, I am stuck try to find the Kilowatt Hours. This is the error The 'SolarBot Status Averages' report doesn't show the correct fields.

    ReplyDelete
  26. AnonymousMay 4, 2023 at 6:28 PM

    We can't find a page with the name 'SolarBot Status Page With Chart'.I cant save the page error is showing me "Developer name has to be unique" please advice me how to save this page.

    ReplyDelete
  27. AnonymousJuly 13, 2023 at 7:01 AM

    Challenge Not yet complete... here's what's wrong:
    We can't find a graph displaying the requested data on the 'SolarBot Status Averages' report

    ReplyDelete
  28. AnonymousNovember 7, 2023 at 10:28 PM

    Challenge Not yet complete... here's what's wrong:
    We can't find a graph displaying the requested data on the 'SolarBot Status Averages' report.

    ReplyDelete
  29. AnonymousJanuary 15, 2024 at 8:58 AM

    We can't find a graph displaying the requested data on the 'SolarBot status Averages' report

    ReplyDelete

Post a Comment

Popular posts from this blog

Service Cloud Specialist Superbadge - 4,5,6,7

Part of doing the Service Cloud Specialist superbadge is trying new things, so I am putting up picture of new things that I've tried recently.  One of my favorite new things this week was taking a shower with my whole block collection.  Mom put me in the shower, and I sneaked out to grab the block bin and dumped it in.  I'm concerned to share photos because of the slight nudity, however, I can assure you that it was a glorious adventure.  Instead, I'll share my favorite Saturday new thing- walking to the coffee shop for a sprinkle donut!  Back to the superbadge... Challenge 4 Case Routing If you haven't taken the Onmi Channel module yet, now is a good time! I kept that particular module open one on screen while I walked through this step.  It is hard to give many hints about this step without giving away too many details - so - the best advice is to read through the challenge and label each step with the corresponding Salesforce term.  (IE - "The...
191 comments
Read more

Business Administration Specialist Superbadge- 3 & 4

This afternoon, I added a genius wig in an attempt to look a little older and more experienced.  The free lemonade offer worked!  I made two dollars today!  A huge thank you to Jocelyn Fennewald , Salesforce MVP, for pointing out the "remove all columns" option within the report creator.  When you start a create a new report, simply click to start with a clean screen.  If you are familiar with report and dashboards, this challenge should only take 30 or so minutes to complete.  Below are tips and gotchas for each report / dashboard.  If you need more help, leave a comment! Reports Accounts by Market To create the "Market" row grouping, use a bucket field. Make sure that the correct date range is selected. High Value Residential  This report includes: 1 filter, 1 grouping, and 1 summarized field.  Rated Accounts by State The record count for state and account rating are automatically added. Note the filter.  ...
134 comments
Read more

Service Cloud Specialist Superbadge - 1,2,3

A confession - I know next to nothing about service cloud.  While I was excited that a new superbadge was available, it made me a little nervous that I had to do all of the prerequisites and tackle new things like macros.  New things - new year - let's get started! (Right after I finish guitar practice) If you are also a service cloud novice, the Omni-Channel Basics is a crucial prerequisite even though it is not officially required. Challenge 1 App Appearance  This, like all superbadges, requires a careful read through the instructions prior to any clicking.  I found it helpful to take a separate notebook and write down the steps that I would need for each challenge step - for example -  My rough notes for challenge 1: Create 2 profiles  Tweak service Console 3 new items on utility bar Allow access for new profiles Create User  Beware - After editing the service console, you might have to edit the new profiles.  I found i...
155 comments
Read more