function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Christopher Hart 18Christopher Hart 18 

Lightning Experience Reports and Dashboards Specialist #7 Challenge

I have read as many thread about this as I can without resolving the issue. The directions specifically state the range of Stage for the Y axis is from Qualification to Closed Won. You can modify the right side of the range with Maximum Groups Displayed = 9. There doesn't seem to be a way the eliminate the Stage= Prospecting in front of Qualification without modifying the report first. 

Challenge Not yet complete... here's what's wrong: 
The 'SolarBot Pipeline by Stage' component doesn't display data in the correct format or doesn't show both side-by-side bars correctly.
Close errors

I have set up the chart as follows:
Report = SolarBot Loyalty Revenue
Type = Verticle Bar Chart
X-Axis = Stage
Y-Axis = Sum Expected Revenue; Adjusted Expected Revenue
Unit= Thousands
Sort Rows= Label Descending
Maximum Rows Displayed = 9
I have tried it with both Light and Dark Themes.

Any ideas
Khan AnasKhan Anas (Salesforce Developers) 
Hi Christopher,

Greetings to you!

You have to set it up like this:

SolarBot Pipeline By Stage:
Report: SolarBot Loyalty Revenue
Display as: Vertical Bar Chart
X-Axis: Stage
Y-Axis: Sum of Expected Revenue, Adjusted Expected Revenue 
Display Units: Thousands
X-axis Range: Automatic
Decimal Places: Automatic
Sort Rows: Labels Ascending
Max groups Displayed: 9 
Title: SolarBot Pipeline By Stage
Legend: Right
Component Theme: Dark

Please REFRESH THE DASHBOARDS before checking up the challenge.

I hope it helps you.

Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in the future. It will help to keep this community clean.

Thanks and Regards,
Khan Anas
Saravanan RajarajanSaravanan Rajarajan
Hi Christopher,

You have to set it up like this:

User-added image

User-added image

User-added image

Check once your setup also same. if any queries please let me know.

Please mark it best answer if it helps you.
Nakul MalhotraNakul Malhotra
While adding a component in the dashboard, I only see sort by- Stage, whereas in the above screenshots shared it is sort rows by: Label ascending is shown. Any reason why I see different sorting field label and its different value? 
User-added image
Phanith LimPhanith Lim
@Nakul Malhotra I am having the same issue, did you ever get it resolved? 

Clinton TaylorClinton Taylor
@Phanith Lim I was having the same problem, so I filtered out 'Prospecting' from the SolarBot Loyalty Revenue, it seemed to do the trick
Michele FosterMichele Foster
How did you filter out Prospecting? I've been trying to figure that out and I'm stumped.
Clinton Taylor 6Clinton Taylor 6
I filtered it out of the SolarBot Loyalty Revenue report, then check challenge. I did need to remove this filter later on for another part
shyamala sudhir 3shyamala sudhir 3
@Khan Anas @Saravanan Rajarajan, Hello, Both, would either of you be able to help with some clarification on the question from @Nakul Malhotra. I also see only a "Sort by" option and not "Sort Rows by". I could not clear the first step for two days and am wondering if I am missing something there. I deactivated the Prospecting value in the picklist to have it excluded from the list as it kept getting displayed otherwise. Filtering also did not help in fixing the error message - about the size and position of the component. Thanks for your help with this! Regards!
Samantha Cordero 284Samantha Cordero 284
@shyamala sudhir 3 did get an answer? I am having the same problem as you. I only have the sort by and not sort by rows. 
shyamala sudhir 3shyamala sudhir 3
It seems to be a label change in the latest development environment. I got no response, Samatha! Regards! Shyamala
Barb LeungBarb Leung
Hi all,
Did you get answer?  I am doing this one now and passed.  I don't have the ascending, but I do have sort by stage, and then click the arrow on the right of it to sort by ascending after filtering out the stages on the report itself.  sharing screenshot.  hopes this helps.User-added image