Open CertifiedOnDemand.com Section Resources
This is not an exhaustive list; additional resources are referenced within objectives below.
| Objective | Resources | Key Facts |
|---|---|---|
| Describe the capabilities of reports and dashboards. | Reports and Dashboard Quick Start [Should / Various / Salesforce.com] Build a New Report [Could / Various / Salesforce.com] | A report allows you to quickly summarize and chart record data. A dashboard can present summary data from multiple reports on a single page. |
To view the remainder of this content, you must purchase the Salesforce.com Certified Administrator Study Guide. Please Login or purchase the study guide.
Hi John,
this topic ,Understanding Relative Date Values for Filter Criteria, isn’t navigating to a valid page
Updated, thanks
A divisional manager wants to add a chart into a page layout, Which report format can be used as the source report to accomplish this?
Choose 2 answers.
A. Matrix format with a chart.
B. Joined format with a chart.
C. Tabular format with a chart.
D. Summary format with a chart.
Hi John,
Working in the professional edition…I am unable to create a new dashboard as the reports tab does not display the new dashboard button..just the new report is present. Also, unable to create a new report folder/dashboard folder as the folder icon with the drop down…new report folder..new dashboard folder is not there. Why are these features not available?
I was in Group Edition, not Professional….
Are you logged in a system admin? I’m not sure specifically which features are available in group, I would make sure that dashboards are included
Hi john,
I have a question regarding External Users. My community users could not see fields on reports. They have complete access to these fields.
They could not see the fields of Contact Object
I created a custom object Related Contacts gave a master detail relationship with Contacts on this field.
I created a report on Related Contacts. The reports has contact fields to. I gave access for this folder. But the community user could only see all the fields of Related Contact but not the Contact.
Please help me with this.
Thank you,
Alekhya.
I would guess that you need to look at the record level access to the contacts – community users can use a different record access model (sharing sets). I would check your community security settings-
If you have your dashboard as “Run as specified user” and if the user clicks on the dashboard component to view the report, what kind of access do they have then?
They’d get the results of the records that they can view in the system (the same as reports) instead of the results of records that another user could view
Quiz repeated
Not sure how that happened- fixed, thanks
Reports and Dashboards Quick Start is repeated on first section.
Thanks, updated
Hi John,
1)I am also unable to see folder sharing in my setup to enable reports and dashboard enhanced access.any specific reasons?
2) Under view access levels for reports and dashboards it says..”With Viewer access you can see the data in a report or dashboard, but you can’t make any changes, except by cloning it into a new report or dashboard.” while on the comparison between viewer,editor and manager access page it states the opposite i.e. you can change a report with viewer access.I am not clear on this.could you please clarify?
3)Also would you be able to point out a resource on dashboard components and an example/demo for reporting snapshots..
appreciate your help..
thanks
rashminder
#1 – turned on by default most likley (will add a note to the content about this)
If your organization was created after the Summer ’13 Salesforce release, you already have analytics folder sharing. If your organization existed before the Summer ’13 release, follow these steps to make folder sharing available to your users.
#2 viewer can view but not edit, editor and manager can edit reports inside
#3 a common example would be trend analysis – e.g. change in the opportunity pipeline over time
In the KEY FACTS for “Describe the capabilities of custom summary formulas” the note says the following. I think, instead of “maximum” this should say “sum”.
A custom summary formula is different than a custom formula field. In the above scenario, a custom formula field cannot calculate the maximum value of all won opportunity records, and thus could not be used to calculate a percentage of that maximum.
Forgot to hit “Notify when new comments are added” checkbox and hence adding this comment…
Good point – updated
Hi John,
I have purchased the study guide however when ever I click on any link am getting following message
To view the remainder of this content, you must purchase the Salesforce.com Certified Administrator Study Guide. Please Login or purchase the study guide.
Please email your transaction details to the support email (listed on the contact page). It is likely that your transaction was not completed- if your credit card/paypal was billed we will certainly make sure you have access. If you had two accounts, please make sure you are on the right account as well.
Hi,
Dynamic Dashboards deliver data based on login credentials of the user viewing the report as opposed to the “running user”
TRUE
FALSE
?
As opposed to a named running user, yes- please don’t double post.
Hi John ,
To my understanding we could use report charts(directly on report w/o dashboard) only on Summary and Matrix type reports , but recently i read that joined reports also support that . If that is true what would the correct answer of the following question :-
34. A divisional manager wants to add a chart into a page layout
Which report format can be used as the source report to accomplish this?
Choose 2 answers.
A. Matrix format with a chart.
B. Joined format with a chart.
C. Tabular format with a chart.
D. Summary format with a chart.
I think quality for Custom Summary Formula is much better in this video: https://www.youtube.com/watch?v=a9CZkXxPOXU
Good Salesforce 8-page PDF “Historical Trending” resource: Reporting on Historical Changes in your Data [last updated 1/25/17]
https://resources.docs.salesforce.com/206/latest/en-us/sfdc/pdf/salesforce_opportunity_trending_cheatsheet.pdf
Plenty of use case examples – still only limited to 3 months of data. This course has been excellent about introducing features that I didn’t even know existed!
Great resource, thanks! Added to the list.
hi john/all, just sharing this in case it may be helpful .. there are lots of mock exams that say that you can’t use a tabular report as a source report for dashboards – but salesforce says:
“You can use a tabular report as the source report for a dashboard table or chart component, if you limit the number of rows it returns”
https://help.salesforce.com/articleView?id=reports_tabular_in_dashboards.htm&language=en_US&type=0
found another link where salesforce says:
“Tabular reports are the simplest and fastest way to return your data in a simple list view format. Keep in mind that tabular reports can’t be used to create dashboard components.”
https://help.salesforce.com/articleView?id=000025298&type=1
just tested this in my dev org – the link in my first comment is correct – i.e. you can use a tabular report as the source report for a dashboard component, bearing in mind:
1) component should be table or chart and
2) you need to limit the number of rows returned on the tabular report
Great tips!
Hi John,
You refer to standard and custom report ‘types’. Are you interchanging ‘type’ with ‘format’ here?
Thanks
NVM, looks like you’re referring to the Object from which to build the report. Thanks
Hi John, Also the following section, ‘Build a Custom Summary Formula’. Thanks again!
Thanks! Fixed
HI John, when clicking on ‘Choose a Report Format’ section, I’m getting ‘Invalid language code. Check that the language is included in your Knowledge language settings’. Thanks.
Updated, thanks
Hi John, I am not able to determine reason for reporting snapshot. Will it not be more useful to have audit trail data used for discovering trends over timeline? Reporting snapshot will not capture all transitions of data and will capture only snapshot at scheduled point in time. Am I missing something here.
Also does SF allow integration with third party ETL tools or snapshot is the only way to do it.
Regds
Nikhil
Yes you can integrate to a data warehouse, which would be the most robust solution (or look at using wave). The idea is that you can capture the data at a point in time… e.g. compare the sales pipeline at the start of the month to the end of the month. You could do this with filters (e.g. opportunity created date), but the only way to compare the entire pipeline would be to capture the report data at the point in time when it was run (snapshot)
Which dashboard components can display data from summary rows of a reports ? –> Is it chart and tables or matrix and Gauge. It was a exam question. I passed the admin (201) exam today. Thank you John for hosting this site
Awesome thanks- and congrats! Not sure exactly what the question is getting at – as both can summarize data points. Metric and gauge can apply feedback within the chart (e.g. 90k — goal is 100k … where 100k is stipulated in the dashboard component).
Hello John
Dont you think the security related content here has become outdated after enhanced sharing is enabled by default?
I’ll take a look at that, probably time for me to spin a new DE org
Hey, I cant find an option to create a custom summary formula in the report builder, do I need to set it up somewhere?
Left hand side, list of fields in a summary or matrix report
Hi John
some of the videos under data management and analytics are not working
eg. custom summary formulas. Salesforce.com PARENTGROUPVAL Report Formula
i am suing a mac book pro
Fixed, thanks for the heads up
Hi john,
i have question related sharing my report and Dashboard to another user in my org.
as before i do have Campaign report and dashboard..and i came to the point i m shring that borht folder(report and Dashboard) to the user who can access..
@ that point 3 options are available.
1)Viere
2)Editor and
3)Manager.
first 2 i can understand..
but i m confuse abt manager option.
so at that access level…is that the particular user i need to select who is at manager level..or i want to give all the right to any user i want to share this dashboard and report with..
and if something if it should be manager then i can go and select Role rather then the user ,right?
and in other case where i wan to select user and want to give all the access what defined by Manager option at sharing point of any report and dashboard..
am i right?
Thank you .
Tejal.
Correct- manager is required to share the folder: https://help.salesforce.com/HTViewHelpDoc?id=analytics_share_folder.htm&language=en_US
john,
Sorry didn’t get u , i think u r thinking my question like this”does manager required to share the folder”,
but i m not in that point, i m saying if i want to share to a user with manager access level… (report and my dashboard.)..
that user should be the manager or any other person (same peer) , can i share it with manager access level?
Hello john,
Im on the stage where i m really now good implementing reports and dashboards,
Thanks to this site off course.
but i m confuse at some point..
so craving for ur help.
for my question ..baseline consideration are
.baseline consideration are
scenario between 3 users in my org:
User 1: SAD
(license type…System Admin) that’s me ..:)
User 2: SPUC
( license type……Standard Platform User Clone)
User 3: SUC
( license type………..standard User Clone) user
my question is…
When i have report and dashboard, as admin, and i do want to share with some user that is SUC and SPUC.
I have campaign related report type and Dashboard.
and i want to share it with Suc and Spuc.
i m able to share it with Suc but not able to share and display Dashboard chart with Spuc..
what i m assuming is …Spuc user profile limiting him to access campaign…as the profile access limit to the obj. Campaign…
and Suc user is able to see that same Dashboard as it’s profile is having access to campaign..
—–>pls tell me if i m in wrong assumption that ,…profile have some thing to effect with user at dashboard shared folder for certain object access.
——> and further ,,,what if i o want SPuc User want to share my Dashboard of campaign report and i want him to give me green signal that he can really see my chart…?
and one more thing i want to understand is…does this all scenario also effected by OWD settings as well.
what if i change OWD for al users and for Suc who can ok to see my chart for campaign, i restrict him…@OWD .@record access to my campaign related records..?
i know its really that u might think i might should go and explore by my self..trust me………i did try.. ..
but really i m not able to conclude my problem.
Your explanation will sure helping me all the time ,,and sure it will help me if u really give some advance idea…
Thank you.
Tejal @Learning mode.
Yes the user needs to have a license type that supports the objects in order to run a report on them- regardless of profile or OWD settings. Your platform user should not be able to report on the campaign records for that reason.
I am not sure why I cannot find Folder Sharing for report and dashboard via customize->setup. Assumed it was changed in winter14 . Cheers,
This setting? https://help.salesforce.com/htviewhelpdoc?err=1&id=analytics_sharing_enable.htm&siteLang=en_US
Have you searched in setup for “Folder”?
I have the same issue as “crystalq”. My search in setup for “folder” doesn’t find anything.
I have the same issue as well.
And to answer your question, John, yes. I searched in the quick find under setup for folder and it does not yield any results.
You probably can’t turn it off in new orgs:
If your organization was created after the Summer ’13 Salesforce release, you already have analytics folder sharing. If your organization existed before the Summer ’13 release, follow these steps to make folder sharing available to your users.
Hi John,
I logged in as a user with system admin profile in my current development environment and found report builder did not work. Report wizard did work instead.
However, when I logged in as a user with standard user profile , the report builder did work.
Could you have an idea how to troubleshoot and fix the issue?
Many thanks,
-Crystal
I believe this is the issue you are describing: https://success.salesforce.com/answers?id=90630000000gnfEAAQ
Hi John,
The layout of Help and Training changed a week or two ago. I can’t find the first link: Getting Started on Reports and Dashboards.
Thanks.
https://help.salesforce.com/HTViewQuickStarts?id=000113375&language=en_US
Find it here, top right hand side. 🙂
Thanks, updated
In your key facts you say “A custom summary formula is different than a custom formula field.” Can you actually create a custom formula field (column) in a report, or only reference a custom formula field that is in an object?
You can reference a custom formula field in a report, yes (this field would need to be created on the object). A custom summary formula (created within the report) is only accessible within the report in which it is created, and cannot be referenced on the object.
Thanks for your response John. Here’s the full question –
which dashboard component can display data from the summary rows of reports?
(2 answers)
a.Gauge
b.Table
c.Chart
d.Metric
Should be table and chart – definitely a good exercise to test out. Not a bad question.
I have a question about dashboard component. Tried testing but still unsure.
In one of the quizzes it is asked which dashboard component can display data from the summary rows off a report.
I think it is Table and Metric, but could also be Gauge and Chart.
Any thoughts? Anyone ?
I’d have to have the full question for context – most of the dashboard components are used to summarize data however…
Hi John, Great section and thank you for your hard work.
I was a little confused between these 3 terms:
1. ‘Analytic Folder Sharing’
2. ‘Enhanced Sharing for Reports and Dashboards (access levels).’
3. ‘Enable Access Levels for Sharing Report and Dashboard Folders’ (The check box setting that appears under Setup->Customize-> Reports and Dashboards –> Folder Sharing)
Are all 3 the same thing?
Thanks.
Yes I believe these are all referencing the same sharing mechanic – that is the ability to define different tiers of access to reporting/dashboard folders (that is essentially one feature, although the configuration to enable has a few different associated terms).
To further clarify/confirm with respect to this sharing model… If the report folder sharing is set to Edit but a user’s permissions (either through profiles or other sharing mechanisms) for the object to which the report applies is more limited, the permission controls access to the report in the folder, right?
I would expect that to be the case, but haven’t specifically tested it. If you get a chance to test it I would love to hear confirmation.
Could you say that cross object filters are a quick way to replicate some of the functionality of custom report types? For example, if I only need to filter by criteria on a certain object, but not include any fields from that object in my report.
Yes exactly the case – in fact before cross filters existed you would have to create a custom report type.
What would be the different use cases for Historical Trending Reports vs Analytics Snapshots?
Trending reports are done on the record level and store historical changes about that particular record. Snapshots can be done at the record level as well – but are really capturing historical report data (that report data can be include record data). For example, you could use a snapshot to record summary within an opportunity pipeline report – e.g. # opps, amount, etc. at X date. You could store that data in a custom object and then report on that summarized data, establishing a trend of the pipeline itself over time. Great question Alex – I will make a note to clarify this material next pass through.
It seems too like Historical Trending reports have limits on the time frame that you can look at– up to 5 dates in the past if I remember correctly. Whereas Analytic Snapshots could look at any or all days since the snapshot object has been configured.
Working fine now… Thanks.
Report Types video is giving an error.
http://classic.certifiedondemand.com/report-types/
thanks
Which video? Not seeing an error.
nevermind, I see it now.
I can’t find the ‘opportunity status’ field as referenced in the Analytics workbook (http://www.salesforce.com/us/developer/docs/workbook_analytics/workbook_analytics.pdf). I don’t think I’ve re-named any fields. Is it the same as ‘stage’?
Hi John. I created a report folder and a report in it. I did not share the access to the folder with any users. Still users with “Manage Reports in Public Folders” and “Create and Customize Reports” permission in their profiles are able to view and customize the report. The users do not have any other permission set or sharing rule.
What I have understood is if the folder access is not shared with anyone then the folder should not be visible to anyone and also users should not be able to customize the report. What have I missed?
A user with access to manage public report folders would have access to all report folders (that’s the intention of the permission). Generally speaking that is true- without elevated privileges and unshared private folder would not otherwise be visible.
Ok, thanks for the reply. Now I’ve disabled the “Manage Reports in Public Folders” permission and only enabled the “View Reports in Public Folders” and “Create and Customize Reports” permission. Still the user is able to edit the report in a folder which is not shared with anyone.
View Reports in Public folders is likely granting the user permission to all public report folders. This might help: https://help.salesforce.com/HTViewHelpDoc?id=access_report_folders.htm&language=en_US
Makes sense. Thank you.
For a question like this:
A user can only report on information they have “read” access to.
True
False
What would the answer be?
Wouldn’t it be false since a user can also report on information that they have read/write access to?
The site I was taking the test on gives the answer as True. I’m not sure what is correct.
I would say true. Read/write implies the user also has read access. What the question is trying to ascertain is if a user can report on data they don’t have access to – which of course they cannot.
Getting Started With Report and Dashboard link is wrong, the new link is https://lms.cfs-api.com/v1/12/lms.aspx?hash=WUlRa1pjd0RRUDYrZVh6cUtFcVpCVGg3LzVnNFpwSkF0SktWaWxmMG03TFFaaEhTUDlCWWtJQUl4cXZpcm5NUy85bXdQempGbHpLQXEya1Fpb0I5bEVscU9EWExYUHdXQkdxTXRDTEIrTEp0SUh4c3hXUG4yeTVjRU5JYWhGaFdmdmVYRm9UM3poL24wRVN3WjIzeE13PT0=
Help portal still appears to work for me- have avoided using direct links as they change somewhat often…
In another comment, someone mentioned that the plural form of axis is axes. You responded asking where you had used the term – I think I found it. The second objective, in your description of the Matrix report type. I don’t know why that stuck with me!
Taking my exam tomorrow AM – wish me luck! Your site has really helped me so far, we’ll see if it pays dividends!
Nailed the exam this morning. Your site was definitely my #1 resource. Before I found your site, I watched the Admin 201 video series on the Salesforce.com partner training portal. Your detailed information really helped fill in the gaps. Thank you so much!
And a big congrats Paul!
Well my grammar is generally pretty good, but English doesn’t make much sense. Thanks, updated!
‘How to use cross filters in Salesforce Reports’ has been updated: http://www.youtube.com/watch?v=P3jylFrXhow
Thanks, updated
The “Bucketing in Reports” video has been updated — the new one is at http://www.youtube.com/embed/QFYEtBtLHG4
This appears to be the same URL referenced above?
The “Bucketing in Reports” video has been removed from Youtube?
Found the same issue and searched YouTube…found this video that may be a replacement:
https://www.youtube.com/watch?v=Dq1TkYzT-mM
Great thanks all – updated
there are some practical examples at http://www.salesforce.com/us/developer/docs/workbook_analytics/workbook_analytics.pdf
Yep – this listed within the second to last objective.
To all of the people looking to take the exam, I would highly recommend building a few reports and dashboards. Learn about the sharing/security around these as well. Reflecting back on the exam I recently passed, I would say that this section is definitely worth it spend a bit longer in this section. Also, would recommend going back through this guide and reading the ‘key facts’ that John has posted.
Thanks for the feedback Taurean. I’ll consider adding some content (exercises) to this section as well.
Thank you for the heads up!!