Reports & Dashboards Flashcards
What are the 4 reports types available?
- Tabular
- Summary
- Matrix
- Joined
The Tabular Report
You can:
- Use to make a list
- Supported in Dashboards
- Use Fields Buckets
you can’t:
- Report Charts not supported
- Use formulas
The Summary Report
- *You can:**
- Use to Group tows of data and summarize /subtotals
- Supported in Dashboards
- Use Report Charts
- Use Fields Buckets
- Use formulas
- The most commonly used*
The Matrix Report
- *You can:**
- Use to Group and summarize by row and column
- Supported in Dashboards
- Use Report Charts
- Use Fields Buckets
- Use formulas
Report Builder
a visual, drag-and-drop tool that you use to create reports and edit existing ones
Improve Report Performance: Best Practices
- Filter out unnecessary data to return fewer records
- Filter with defined date ranges instead of open-ended relative date ranges
- Filter with EQUALS instead of CONTAINS
- Filter with NOT EQUAL TO instead of DOES NOT CONTAIN
- Don’t filter by row-level formulas
- Remove unnecessary columns
- Write efficient formulas
How can you share Dashboards?
Dashboards are shared via folders. Whomever has permission to the folder your dashboard is saved in also has access to your dashboard. Ensure that you save your dashboard in an appropriate folder.
Dashboard Editor
The Dashboard Editor is a visual, drag-and-drop tool, which you use to create dashboards and edit existing ones. The Dashboard Editor is where you add, edit, and arrange dashboard components.
To launch the Dashboard Editor, click New Dashboard.
Sort Data in Dashboard Components
Dashboard components support two-level sorting.
So you can sort by Stage and then by Sum of Amount, or by Average Age and then Record Count.
What is Dynamic Dashboard?
- People view data according to their own access to data
- Users with “view all data” can choose any user view
- Users with “View My Team’s Dashboards,” can choose any user below in the role hierarchy.
Same as choosing a “running user” Classic
Dynamic Dashboard limitations
- You can’t follow components on dynamic dashboards.
- You can’t save dynamic dashboards in private folders.
- You can’t schedule refreshes for dynamic dashboards. They must be refreshed manually.
- Deleted dashboards that are in the recycling bin count towards the 5 dynamic dashboards limit and must be permanently deleted to no longer count towards the limit.
- You can’t subscribe to dashboards that are set to display data as The dashboard viewer.
What are the available options when choosing “View Dashboard As”?
- Me
- Another person (See data according to the data access level of that person)
- The dashboard viewer (readers see data according to their own access to data - often called dynamic dashboards)
How do you allow viewers to choose whom they view the dashboard as?
Select “Let dashboard viewers choose whom they view the dashboard as” to enable a reader with appropriate user permissions to choose who they view the dashboard as.
- With the “View My Team’s Dashboards” user permission, the reader can view the dashboard as themself or as anyone beneath them in the role hierarchy.
- With the “View All Data” user permission, the reader can view the dashboard as anyone.
Subscribe to Dashboards in Lightning Ex.
- Subscribe to dashboards to refresh them on a schedule that you set (daily, weekly, or monthly),
- Receive the refreshed dashboards results by email.
- You can subscribe to dashboards yourself and also add other users, groups, and roles
- Subscription emails are sent to the email address set in Settings | Email | My Email Settings.
How many dashboard subscriptions can each user set up?
Each user can set up subscriptions for up to 5 dashboards