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. I am stick on Step 6. It cannot not find my solarbot lightning record type page. Any tips here?

    ReplyDelete
    Replies
    1. 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. 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. On the page, is the developer name this: SolarBot_Status_Page_With_Chart ?
      Could you share a few more details?

      Delete
    2. 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. 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. 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. Thank you Anonymous for telling me to go to the "SolarBot" Object. I love you!

      Delete
    6. 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. 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. Could you share some details of your report? On the lighting page, are you filtering the report?

      Delete
  4. 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. 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. Got it figured out. i was using the relative date wrong

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

      Delete
  5. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. What can I do if it won't let me change the unique Salesforce API name?

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

      Delete
    4. 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. 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. 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. 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. Formula is incorrect in syntax- it is missing a "(" and ")" around part of the forumla.

      Delete
    2. 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. 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. 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. 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. Step 2
    #Number of SolarBots int visible inside column

    ReplyDelete
  14. 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. bro pls solve this issue from 2 days i am stucked at this point

      Delete
  15. 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. Same issue here. Have you ever received a suitable answer or resolved it otherwise?

      Delete
    2. Exactly the same for me. Any luck?

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

      Delete
    4. Anyone have solution please give

      Delete
  16. 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
  17. Challenge Not yet complete... here's what's wrong:
    We can't find the correct access configuration for the SolarBot Support Reports folder.

    ReplyDelete
  18. pls help me to solve

    ReplyDelete
  19. 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
  20. 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
  21. We can't find a page with the name 'SolarBot Status Page With Chart'.

    ReplyDelete
  22. 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
  23. 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
  24. 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
  25. 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
  26. 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
  27. 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 channel, Sto

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 it necessary to click "edit&quo

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.  Open Support Cases You ma