Answers - Salesforce Trailblazer Community
Ask Search:
phil levsenphil levsen 
I see that there are many sollutions regarding Step 2 of the Lightning Experience Reports & Dashboards Specialist superbadge.  However I am still receiving the following error and am unable to get around it.
Challenge Not yet complete... here's what's wrong: 
The 'Accounts Without SolarBot Opportunities' report doesn't include the correct collection of accounts.
  •  Standard accounts report type
  • Outline Columns:  Account name, Type, Phone
  • Cross Filters:  Accounts without SolarBots
  • Results showing 12 records
  • Saved as Accounts Without SolarBot Opportunities and placed in the SolarBot Sales Reports folder
have been staring this down for days but am unable to get this report to test out.  Below are my screenshots.
Accounts Without SolarBot Opportunities Outline
Accounts Without SolarBot Opportunities filters
I do not see what is wrong with this report.  would appreciate another set of eyes on this.  thanks.
Best Answer chosen by phil levsen
phil levsenphil levsen
thanks.  that worked.  Will review cross filters again.
Beverley WallaceBeverley Wallace 
In Lightning Reports I have created 4 different folders that contain different types of reports and all my users can view the contents, edit the reports etc. I want to make one of the folders read only as it contains master files that I don't want anyone amending. I have tried sharing the folder with my users and giving them 'View' access howver they are still able to go into the folder and amend and save the reports. I think it has something to do with their permissions but I'm not very familiar with how to set these up. Any help would be appreciated. Thank you.
Best Answer chosen by Beverley Wallace
Sean DukesSean Dukes
Hi Beverley

This is a strange one. Thew answer is that the permission that lets people do this is labelled 'Edit My Reports'. If you uncheck this permission in the profile (you may also need to check any permission sets) then users should no longer be able to save reports in public folders. No. It doesn't make any sense to me either, but it does work.

​​​​​​​Unchecking the permission does not stop users from editing their own reports.

There is an article that clearly states this here: https://help.salesforce.com/articleView?id=000333874&type=1&mode=1

Sean :)
Steve MolisSteve Molis 
Here's a Formula I built to create an "Ultimate Parent Account" field that you can use to create Opportunity Pipeline reports that roll up all Opportunities under the top Account in the hierarchy. 

*** in this example I'm testing up to a 5 Tier Account Hierarchy (Compiled size: 342 characters) ***

Datatype: Formula 
Result: TEXT 
Formula: 
 
IF(NOT(ISBLANK(Parent.Parent.Parent.Parent.Parent.Name)), Parent.Parent.Parent.Parent.Parent.Name,
IF(NOT(ISBLANK(Parent.Parent.Parent.Parent.Name)), Parent.Parent.Parent.Parent.Name,
IF(NOT(ISBLANK(Parent.Parent.Parent.Name)), Parent.Parent.Parent.Name,
IF(NOT(ISBLANK(Parent.Parent.Name)), Parent.Parent.Name,
IF(NOT(ISBLANK(Parent.Name)),Parent.Name,
Name)))))

 
Best Answer chosen by Miglena (Salesforce.com) 
Steve MolisSteve Molis
An #AWESOME bonus tip from @Jeremiah Dohn to turn the Ultimate Parent into a Hyperlink to that Account

Datatype: Formula 
Result: TEXT 
Formula: 
 
HYPERLINK('/' + 
IF(NOT(ISBLANK(Parent.Parent.Parent.Parent.Parent.Name)), Parent.Parent.Parent.Parent.Parent.Id, 
IF(NOT(ISBLANK(Parent.Parent.Parent.Parent.Name)), Parent.Parent.Parent.Parent.Id, 
IF(NOT(ISBLANK(Parent.Parent.Parent.Name)), Parent.Parent.Parent.Id, 
IF(NOT(ISBLANK(Parent.Parent.Name)), Parent.Parent.Id, 
IF(NOT(ISBLANK(Parent.Name)),Parent.Id, 
Id))))), 
IF(NOT(ISBLANK(Parent.Parent.Parent.Parent.Parent.Name)), Parent.Parent.Parent.Parent.Parent.Name, 
IF(NOT(ISBLANK(Parent.Parent.Parent.Parent.Name)), Parent.Parent.Parent.Parent.Name, 
IF(NOT(ISBLANK(Parent.Parent.Parent.Name)), Parent.Parent.Parent.Name, 
IF(NOT(ISBLANK(Parent.Parent.Name)), Parent.Parent.Name, 
IF(NOT(ISBLANK(Parent.Name)),Parent.Name, 
Name))))))

 
Cheryl RedmanCheryl Redman 
I am trying to rationalize all the dashboards we use to determine if we should get rid of some.
Best Answer chosen by Phoebe (DO NOT FOLLOW) 
Steve MolisSteve Molis
You could create a Custom Report Type (CRT) and select Report as the Primary Object and Dashboard, and get the Last Run Date =>

User-added image 
Steve MolisSteve Molis 
The "Check Syntax" button in the Formula Editor only tests the Syntax of a Formula, not the Formula Logic.  

For example both ( A + B ) / C and  A + ( B / C ) are Syntactically correct, but they will return completely different (and potentially bad) results. 

Validation Rules are boolean, and so are Checkbox fields.  So if you ever want to test the Logic of a Validation Rule Formula, just create a hidden Formula Field that returns a Checkbox result and then put your Validation Rule Formula in it.

Then create a Report or a List View that displays all of the fields that your Validation Rule is evaluating, and your Formula(Checkbox) field side-by-side to check for loopholes.
User-added image

*** Caveat Alert *** 

Not all Functions, like ISCHANGED and PRIORVALUE are supported in Formula Fields 
Best Answer chosen by Jayson (salesforce.com) 
Steve MolisSteve Molis
PS.  I've added the Validation Rule Test custom Formula(Checkbox) field on most Standard Salesforce objects in the Autumn'19 release of my Custom Formula Field Mix-Tape unmanaged package

The package is free, but if you really like it and are feeling generous, there's a link to my PayPal in the package (no obligation)

Install URL = sforce.co/36wqroz
Password = UoweB33R

User-added image
 
Brendan YoungBrendan Young 
Trying to figure out the easiest way to include all columns in my report. Thanks!
Best Answer chosen by Moderator (salesforce.com) 
James GarfieldJames Garfield
Hey Ron,

Unfortunately there is no 'easy' button like the 'Remove All Columns'

What you can do though however is click each folder (which contains all of the fields)and drop the folder onto the report. This will add all of the fields contained within the folder to the report!

Before:
User-added image

During:
User-added image

After:
User-added image

VIOLA!

Best of luck!
Susan CoombsSusan Coombs 
Does anyone have any tips on how to remove the #Error from the calculation in a matrix report?
User-added image
Best Answer chosen by Jayson (salesforce.com) 
Nirdesh BhattNirdesh Bhatt
Hi Susan,

I think you have to check if a condition to get a value. Please consider https://help.salesforce.com/articleView?id=000322788&type=1&mode=1 (https://help.salesforce.com/articleView?id=000322788&type=1&mode=1
Moumita BhowmickMoumita Bhowmick 
I created a Dashboard folder called SolarBot Dashboards. I gave the share priviledges as required and also created a Dashboard called SolarBot Impact Dashboard. I am trying to add my first report 'SolarBot Pipeline by Stage' here, but every time I try to check the challenge it throws the following error:
There was an unhandled exception. Please reference ID: NPCWSCRF. Error: NoMethodError. Message: undefined method `[]' for nil:NilClass

The Reference ID keeps changing everytime I hit 'Check Challenge'. Have been stuck here for 10 hours. Can someone please help.

I thought of creating a new Trailhead playground but the 'Check Challenge' button for the previous steps were not enabled again once I did, so I have not used my New playground yet. Would really appreciate any help.
Best Answer chosen by Moumita Bhowmick
Prasanth SKPrasanth SK
This was resolved by Salesforce technical team last week, was able to complete the challenge successfully. you won't the get the error anymore. 

Thank you all! 
samson sfdcsamson sfdc 
Subscribe button is shown only for Summary and Matrix format and not for Joined report format.The first image shows the Subscribe button is available for Summary format. The second image is from Joined report format.

Is this a limitation or i'm making a mistake. Please advise

subUser-added image
Best Answer chosen by samson sfdc
Jackie DoanJackie Doan
There are limitations to what you can do with joined reports. Exporting is one of them, it looks like subscribing is another. 
Sharon AylwardSharon Aylward 
A number of acquisitions mean that our company has multiple instances of Salesforce but wants one reporting output. Is there a way that this can be achieved?
Best Answer chosen by Sharon Aylward
Pruthvi RajPruthvi Raj
@SHARON: So each instance will have different reports which will view/return their own instance's data. So YES the results couldn't be viewed in one report.