TECH **Salesforce Administrator Study Guide: Dashboard Components, Filters, and Dynamic Dashboards**

Salesforce Administrator Study Guide: Dashboard Components, Filters, and Dynamic Dashboards

(Hyper-Practical, Zero-Fluff, Production-Ready)

1. What This Is & Why It Matters

You’re a Salesforce Admin. Your VP of Sales just Slacked you:

"The dashboard I built for the QBR is useless—it shows all regions, but I only care about EMEA. Also, the CEO wants to see the same dashboard but filtered for North America. Do I need two dashboards? There’s got to be a better way."

This is where Dashboard Components, Filters, and Dynamic Dashboards save you.

• Dashboard Components = The building blocks (charts, tables, metrics) that display your data.
• Dashboard Filters = Let users slice data without editing the dashboard (e.g., "Show me only Opportunities > $50K").
• Dynamic Dashboards = One dashboard, multiple views (e.g., Sales Rep sees only their deals; VP sees all regions).

Why this matters in production:
- Without filters/dynamic dashboards, you’ll drown in duplicate dashboards (one per region, per team, per quarter). Maintenance becomes a nightmare.
- Without proper components, users get overwhelmed by clutter or miss key insights (e.g., a bar chart vs. a gauge for quota attainment).
- Real-world impact: A poorly designed dashboard = wasted time, bad decisions, and a VP who thinks Salesforce is "too complicated."

Your mission:
Build a single dashboard that: 1. Shows Opportunity pipeline (bar chart) and closed-won deals (metric).
2. Lets users filter by region, stage, and amount without editing the dashboard.
3. Displays only the logged-in user’s data (for reps) or all data (for managers).

2. Core Concepts & Components

? Dashboard

• Definition: A visual representation of data from one or more reports.
• Production insight: Dashboards are not reports—they display reports. If the underlying report changes, the dashboard updates automatically.
  ⚠️ Trap: Users often edit the dashboard instead of the report, breaking the link.

? Dashboard Component

• Definition: A single visual element (chart, table, metric, gauge) on a dashboard.
• Types:
• Chart: Bar, line, pie, funnel, scatter, etc.
• Metric: Single number (e.g., "Total Revenue: $1.2M").
• Table: Tabular data (e.g., top 10 deals).
• Gauge: Progress toward a goal (e.g., quota attainment).
• Visualforce Page: Custom component (advanced).
• Production insight: Gauges are great for KPIs (e.g., "85% of quota met"), but they require a target value in the report.

? Dashboard Filter

• Definition: A dropdown or toggle that lets users change what data appears without editing the dashboard.
• Types:
• Standard Filter: Pre-defined options (e.g., "Region: EMEA, NA, APAC").
• Date Filter: "Last 30 days," "This quarter," etc.
• Field Filter: Filter by any report field (e.g., "Amount > $50K").
• Production insight: Filters only work if the underlying report has the field you’re filtering on. If the report doesn’t include "Region," you can’t filter by it.

? Dynamic Dashboard

• Definition: A dashboard that automatically adjusts based on who’s viewing it.
• Key features:
• Running User: Who the dashboard "runs as" (e.g., "Show data for the logged-in user" vs. "Show all data").
• Personalization: Users can save their own filter settings.
• Production insight: Dynamic dashboards reduce admin workload (no need to clone dashboards for every team). But they require careful permission settings—if a rep can’t see a record, it won’t appear in their view.

? Report Type

• Definition: The "blueprint" for what data a report can include (e.g., "Opportunities with Products").
• Production insight: If you need a field in a dashboard (e.g., "Product Family"), the report must use a report type that includes it.

? Dashboard Folder

• Definition: Where dashboards are stored (like a file folder).
• Production insight: Dashboards inherit permissions from their folder. If a user can’t access the folder, they can’t see the dashboard—even if they’re the "running user."

3. Step-by-Step: Build a Dynamic Dashboard with Filters

Prerequisites

• You have System Administrator permissions.
• You have at least 10 Opportunities in your org (with fields like Amount, Stage, Region, Owner).
• You’ve created a report folder (e.g., "Sales Dashboards") and a dashboard folder (e.g., "Executive Dashboards").

Step 1: Create the Base Report

Goal: Build a report that feeds your dashboard.

1. Go to Reports > New Report.
2. Select Report Type: "Opportunities" (or "Opportunities with Products" if you need product data).
3. Set Filters:
4. Show Me: "All Opportunities"
5. Date Field: "Close Date"
6. Range: "Current and Next Fiscal Quarter"
7. Add Columns:
8. Opportunity Name
9. Amount
10. Stage
11. Region
12. Owner > Full Name
13. Group Rows by: "Stage" (for the bar chart).
14. Save:
15. Name: "Opportunity Pipeline - Base"
16. Folder: "Sales Dashboards" (must be accessible to dashboard users).

✅ Verify: Run the report. You should see Opportunities grouped by Stage.

Step 2: Create the Dashboard

Goal: Build a dashboard with a bar chart and metric.

1. Go to Dashboards > New Dashboard.
2. Name: "Sales Pipeline - Dynamic"
3. Folder: "Executive Dashboards".
4. Add Components:
5. Bar Chart:
   • Click Add Component > Chart.
   • Select report: "Opportunity Pipeline - Base".
   • Chart Type: Horizontal Bar.
   • X-Axis: "Sum of Amount".
   • Y-Axis: "Stage".
   • Title: "Pipeline by Stage".
6. Metric:
   • Click Add Component > Metric.
   • Select report: "Opportunity Pipeline - Base".
   • Metric: "Sum of Amount".
   • Title: "Total Pipeline Value".
7. Save.

✅ Verify: Run the dashboard. You should see a bar chart and a metric.

Step 3: Add Dashboard Filters

Goal: Let users filter by Region, Stage, and Amount.

1. Click Edit on the dashboard.
2. Click Add Filter (top-right).
3. Add 3 Filters:
4. Filter 1: Region
   • Field: "Region"
   • Operator: "equals"
   • Default Value: "All" (or leave blank)
5. Filter 2: Stage
   • Field: "Stage"
   • Operator: "equals"
   • Default Value: "All"
6. Filter 3: Amount
   • Field: "Amount"
   • Operator: "greater than"
   • Default Value: "0"
7. Save.

✅ Verify: - Run the dashboard.
- Change the Region filter to "EMEA". The bar chart and metric should update.
- Change the Amount filter to "> $50,000". Only high-value deals should appear.

Step 4: Make It Dynamic

Goal: Show data for the logged-in user (for reps) or all data (for managers).

1. Click Edit on the dashboard.
2. Click Dashboard Properties (gear icon).
3. Set Running User:
4. View Dashboard As: "The dashboard viewer" (dynamic).
5. Let authorized users change running user: ✅ Checked (optional, for admins).
6. Save.

✅ Verify: - Log in as a Sales Rep (e.g., "John Doe").
- Run the dashboard. You should only see John’s Opportunities.
- Log in as a Manager (e.g., "Sarah Smith").
- Run the dashboard. You should see all Opportunities (if Sarah has "View All" permissions).

Step 5: Personalize for Users

Goal: Let users save their own filter settings.

1. Run the dashboard (as any user).
2. Set filters (e.g., Region = "NA", Amount > $100K).
3. Click Save View (top-right).
4. Name: "North America - High Value"
5. Save.

✅ Verify: - Log out and back in.
- Run the dashboard. Your saved view should appear in the dropdown.

4. ? Production-Ready Best Practices

Security

• Folder Permissions: Dashboards inherit permissions from their folder. Put sensitive dashboards in a folder with restricted access.
• Running User: If using "Let authorized users change running user," ensure only admins/managers have this permission (to avoid data leaks).
• Field-Level Security: If a user can’t see a field (e.g., "Forecast Category"), it won’t appear in filters—even if the report includes it.

Performance

• Limit Components: Each component runs a separate report query. Too many components = slow dashboard.
• Max: 20 components per dashboard (Salesforce limit).
• Best Practice: 5–7 components max.
• Avoid "View All" Reports: If a report returns 50K rows, the dashboard will time out. Use filters to limit data.
• Schedule Refreshes: Dashboards don’t auto-refresh. Schedule them to run overnight if data is static.

Maintainability

• Naming Conventions:
• Reports: [Object] - [Purpose] - [Filters] (e.g., "Opportunity - Pipeline - EMEA").
• Dashboards: [Team] - [Purpose] (e.g., "Sales - QBR Pipeline").
• Documentation: Add a Text Component at the top of the dashboard with:
• Purpose (e.g., "Shows pipeline for current quarter").
• Filters available.
• Last updated date.
• Version Control: Clone dashboards before major changes (e.g., "Sales Pipeline - v2").

User Experience

• Default Filters: Set sensible defaults (e.g., "Current Quarter" for date filters).
• Hide Irrelevant Filters: If a filter isn’t useful for most users, remove it.
• Mobile-Friendly: Test dashboards on mobile. Some components (e.g., tables) don’t display well.

5. ⚠️ Common Mistakes & Traps

6. ? Exam/Certification Focus

Typical Question Patterns

1. "Which dashboard component is best for showing quota attainment?"
2. ✅ Gauge (shows progress toward a target).

3. ❌ Bar chart (good for comparisons, not progress).

4. "How do you let users filter a dashboard by Region?"

5. ✅ Add a dashboard filter for the "Region" field.

6. ❌ Edit the underlying report (users can’t change report filters without editing).

7. "A sales rep complains they see all Opportunities, not just theirs. What’s wrong?"

8. ✅ The dashboard is set to run as a specific user (e.g., admin) instead of "The dashboard viewer."

9. ❌ The rep lacks permissions (if they can’t see their own records, that’s a separate issue).

10. "Which feature lets users save their own filter settings?"

11. ✅ Dashboard Views (Save View button).
12. ❌ Dynamic Dashboards (this controls who sees data, not how it’s filtered).

Key ⚠️ Trap Distinctions

Scenario-Based Question

"You need a dashboard that shows sales reps only their own Opportunities, but managers should see all Opportunities in their region. What’s the most efficient way to build this?"
- ✅ One dynamic dashboard with: - Running User: "The dashboard viewer." - A filter for "Region" (so managers can select their region).
- ❌ Two separate dashboards (one for reps, one for managers) = maintenance nightmare.

7. ? Hands-On Challenge

Challenge: Build a dashboard that: 1. Shows Cases by Status (pie chart).
2. Lets users filter by Priority (High, Medium, Low).
3. Displays only the logged-in user’s Cases (for agents) or all Cases (for managers).

Solution: 1. Create a report: "Cases - Base" (include Status, Priority, Owner).
2. Build a dashboard with:
- Pie chart: "Cases by Status."
- Filter: "Priority" (equals).
- Running User: "The dashboard viewer." 3. Test as an agent (should see only their Cases) and a manager (should see all Cases).

Why it works: - Dynamic dashboard adjusts data based on the viewer.
- Filter lets users slice by Priority without editing the dashboard.

8. ? Rapid-Reference Crib Sheet

9. ? Where to Go Next

1. Salesforce Help: Dashboards – Official docs.
2. Trailhead: Dashboard Basics – Hands-on module.
3. Salesforce Ben: Dynamic Dashboards Guide – Real-world examples.
4. YouTube: Dashboard Filters Deep Dive – Search for "Salesforce dashboard filters tutorial."