Salesforce Reports & Dashboards Interview Questions [2025] — Complete Guide with Real Examples

📅 Reports & Dashboards

Salesforce Reports & Dashboards Interview Questions

📊 Reports & Dashboards

Salesforce Reports & Dashboards Interview Questions — Complete Guide

Report Types, Dashboards, Bucket Fields, Dynamic Dashboards & More — Explained for Interviews

Intermediate 21 Questions

Question 01

What are the different types of Reports in Salesforce?

✅ Answer

Salesforce has 4 types of reports — Tabular, Summary, Matrix, and Joined — each designed for different reporting needs! 📊

📋 Report Types at a Glance

Report Type	Description	Dashboard Source?
Tabular	Simple list of records like Excel. No grouping.	❌ No
Summary	Groups rows by a field. Supports subtotals.	✅ Yes
Matrix	Groups by both rows AND columns. Two-dimensional.	✅ Yes
Joined	Combines up to 5 report blocks in one view.	❌ No

✅❌ What Each Type Controls

❌Tabular — Cannot be used as dashboard source. No grouping, no charts.
✅Summary — Most commonly used. Supports grouping, subtotals, charts.
✅Matrix — Two-way comparison (rows + columns). Great for pivot-style reports.
⚠️Joined — Advanced multi-block. Cannot be used as dashboard source.

🎤 One-Line Answer for Interview

"Salesforce has 4 report types — Tabular (simple list, no grouping), Summary (row grouping with subtotals), Matrix (row and column grouping), and Joined (up to 5 blocks combined) — with only Summary and Matrix usable as dashboard component sources."

Question 02

What are Joined Reports?

✅ Answer

Joined Reports allow you to combine up to 5 report blocks in a single report view — each block with its own columns and filters — sharing common filters and one chart! 📊

📋 Joined Report Structure

Component	Description
Blocks	Up to 5 report blocks — each like a mini report
Block Columns	Each block has its own independent columns
Block Filters	Each block can have its own filters
Common Filters	Shared filters that apply to ALL blocks
Chart	Only ONE chart allowed per Joined Report

✅❌ What Joined Reports Actually Control

✅Combine data from multiple report types in one view
✅Each block can have different columns and filters
✅Share one common chart across all blocks
❌Cannot be created in Salesforce Classic — Lightning only
❌Cannot be used as a Dashboard component source
❌Cannot have more than 5 blocks
❌Tabular format not supported as blocks

🌍 Real World Example

At Ami Polymer, leadership wants one report showing: Block 1 — Open Opportunities by Territory, Block 2 — Orders Placed this Quarter, Block 3 — Complaints Raised this Month. All 3 in one Joined Report instead of 3 separate reports!

🎤 One-Line Answer for Interview

"Joined Reports allow combining up to 5 report blocks in a single report, each with its own columns and filters, making it ideal for comparing multiple data perspectives — however, they cannot be used directly as a dashboard component source and are available only in Lightning Experience."

Question 03

When to use Joined Reports?

✅ Answer

Use Joined Reports when you need to compare or display multiple related datasets side-by-side in a single report — where switching between multiple separate reports would be inefficient! 📊

📋 When to Use vs When NOT to Use

Scenario	Use Joined Report?
Compare Opportunities vs Cases for same Accounts	✅ Yes
Show Open + Closed + Lost deals together	✅ Yes
Simple list of all Contacts	❌ No — Use Tabular
Group Opportunities by Stage with subtotals	❌ No — Use Summary
Compare revenue by Region vs Product	❌ No — Use Matrix
Need it as a Dashboard source	❌ No — Not supported

🌍 Real World Example

At Ami Polymer, export team head wants to see Quotes sent to Europe, Orders received, and Payments pending — all in one Joined Report instead of opening 3 separate reports!

🎤 One-Line Answer for Interview

"Joined Reports should be used when you need to compare or display multiple related datasets side-by-side in a single view — such as comparing Opportunities, Cases, and Orders for the same Accounts — where switching between multiple separate reports would be inefficient."

Question 04

What are the things which are NOT supported in Joined Reports?

✅ Answer

Joined Reports have several platform-level restrictions — knowing what they CANNOT do is just as important as knowing what they can! ❌📊

❌ Limitations Table

Feature	Supported?
Dashboard Component Source	❌ Not Supported
Salesforce Classic	❌ Not Supported
Tabular Report as Block	❌ Not Supported
More than 5 Blocks	❌ Not Supported
Multiple Charts	❌ Only 1 chart allowed
Bucket Fields across Blocks	❌ Not Supported
Schedule / Subscribe	❌ Not Supported
Export to Excel/CSV directly	❌ Not Supported

🔑 Key Points for Interviewer

🔥Dashboard restriction is the #1 most asked limitation — always mention it first
💡Cannot run in Salesforce Classic — Lightning Experience only
💡Tabular blocks not allowed — only Summary and Matrix type blocks
💡Cannot be scheduled or subscribed — users must manually run it
💡No direct Excel/CSV export like other report types

🎤 One-Line Answer for Interview

"Joined Reports do not support being used as dashboard sources, cannot run in Salesforce Classic, do not allow Tabular blocks, cannot exceed 5 blocks or 1 chart, and cannot be scheduled or exported to Excel — making them powerful for on-screen analysis but limited for automation and dashboards."

Question 05

What is a Bucket Field in Salesforce Reports?

✅ Answer

A Bucket Field allows you to categorize report values into custom groups directly inside the report — without creating any custom field on the object! 🪣

📋 Types of Bucket Fields

Bucket Type	Used For	Example
Numeric	Group number ranges	Amount: 0-10K = Small, 10K-50K = Medium, 50K+ = Large
Picklist	Group picklist values	Stage: Prospecting+Qualification = Early, Proposal = Late
Text	Group text values	Country: India+Pakistan = South Asia, USA+Canada = NA

✅❌ What Bucket Fields Control

✅Group values into custom categories inside report
✅No need to create custom fields on the object
✅Can be used as a grouping column and in filters
❌Limited to 5 bucket fields per report
❌Each bucket supports max 20 bucket values
❌Cannot be referenced in Flows, Formulas, or Apex
❌Cannot be used across blocks in Joined Reports

🌍 Real World Example

At Ami Polymer, categorize Orders by Amount — Small (₹0–1L), Medium (₹1–10L), Large (₹10L+) — using a Numeric Bucket Field directly in the report. No custom field needed! 🎯

🎤 One-Line Answer for Interview

"A Bucket Field in Salesforce Reports allows you to categorize field values into custom groups directly within the report without creating custom fields — supporting Numeric, Picklist, and Text types, with a limit of 5 bucket fields and 20 values per bucket per report."

Question 06

What is Report Type in Salesforce?

✅ Answer

A Report Type is a framework/template that defines which objects and fields are available when building a report — it is the foundation every report is built upon! 🗂️

📋 Standard vs Custom Report Types

Type	Created By	Example
Standard Report Type	Salesforce (Out of Box)	Opportunities, Cases, Contacts & Accounts
Custom Report Type	Admin	Accounts with Orders with Order Products

📋 With vs Without Relationship

Setting	Meaning	Example
A must have B	Show A records that HAVE related B	Accounts WITH Contacts only
A may or may not have B	Show all A records, B is optional	Accounts WITH or WITHOUT Contacts

✅❌ What Report Type Controls

✅Which primary object the report is based on
✅Which related objects can be included (up to 4 objects)
✅Which fields are available in report builder
❌Does NOT control record-level visibility (OWD/Sharing does)
❌Cannot exceed 4 objects in one Custom Report Type

🎤 One-Line Answer for Interview

"A Report Type in Salesforce is a framework defining which objects and fields are available when building a report — Standard Report Types are pre-built by Salesforce while Custom Report Types are created by Admins supporting up to 4 related objects, with deployment status required before users can access them."

Question 07

What is a Report Folder?

✅ Answer

A Report Folder is a container that stores reports and controls access through folder-level permissions — every report must live inside a folder! 📁

📋 Folder Permission Levels

Permission	What They Can Do
Viewer	Can view and run reports only
Editor	Can view, run, and edit reports
Manager	Can view, run, edit, and manage folder contents

✅❌ What Report Folder Controls

✅Who can view, edit, and manage reports inside the folder
✅Can be shared with Users, Roles, Role & Subordinates, Public Groups
✅Admins can always access all folders
❌Does NOT control record-level visibility inside the report
❌A report cannot exist without a folder
❌Cannot share with individual Permission Sets

🎤 One-Line Answer for Interview

"A Report Folder in Salesforce stores and organizes reports while controlling access through three permission levels — Viewer, Editor, and Manager — sharable with Users, Roles, or Public Groups, with every report required to belong to a folder."

Question 08

What is Conditional Highlighting in Reports?

✅ Answer

Conditional Highlighting automatically color-codes summary values based on defined thresholds — making it visually easy to spot high, medium, and low performing data! 🎨

📋 How It Works

Component	Description
Breakpoint 1	First threshold separating Low from Mid
Breakpoint 2	Second threshold separating Mid from High
Low Color	Color applied below Breakpoint 1
Mid Color	Color applied between Breakpoint 1 and 2
High Color	Color applied above Breakpoint 2

✅❌ What It Controls

✅Works on Summary and Matrix reports only
✅Up to 5 conditional highlighting rules per report
✅Applied on aggregate/summary values
❌Does NOT work on Tabular or Joined reports
❌Does NOT work on row-level values
❌Does NOT send alerts — visual only!

🎤 One-Line Answer for Interview

"Conditional Highlighting color-codes numeric summary values using two breakpoints and three color zones — available only on Summary and Matrix reports — making it easy to visually identify performance levels, though it is purely visual with no alerts or automation triggered."

Question 09

What are Best Practices for Reports in Salesforce?

✅ Answer

Best Practices ensure reports are efficient, accurate, maintainable, and user-friendly — separating a good Admin from a great one! ✅📊

📋 Best Practices — Category Wise

Category	Best Practice
Design	Use correct report type for the use case
Design	Add filters to limit data — never pull all records
Performance	Always filter by Date Range to reduce data load
Performance	Use relative dates (This Quarter) not hardcoded dates
Organisation	Store reports in proper folders with correct permissions
Organisation	Use clear, descriptive names and descriptions
Accuracy	Test reports in Sandbox before deploying to Production
Maintenance	Delete unused/old reports regularly

🌍 Real World Example

At Ami Polymer, instead of 10 separate territory reports — build 1 Summary Report grouped by Territory with a Territory filter. Each regional head applies their own filter. One report serves everyone! 🎯

🎤 One-Line Answer for Interview

"Best Practices for Salesforce Reports include using the correct report type, applying relative date filters for performance, organizing reports in governed folders, using clear naming with descriptions, and regularly cleaning up unused reports to ensure accuracy, efficiency, and governance."

Question 10

What Formula types are NOT available on Tabular Reports?

✅ YES — Limitation Confirmed ❌

Summary Formulas and Cross-Block Formulas are NOT available on Tabular Reports — because Tabular has no grouping to calculate against! ❌📊

📋 Formula Availability by Report Type

Formula Type	Tabular	Summary	Matrix	Joined
Row-Level Formula	✅	✅	✅	✅
Summary Formula	❌	✅	✅	✅
Cross-Block Formula	❌	❌	❌	✅

🔑 Key Points for Interviewer

🔥Tabular Reports only support Row-Level Formulas — nothing else
🔥Cross-Block Formulas are exclusive to Joined Reports — most asked trap!
💡Row-Level Formula is the only formula type available across all 4 report types
💡Summary Formulas need grouping — that's why Tabular doesn't support them

🎤 One-Line Answer for Interview

"Tabular Reports only support Row-Level Formulas — Summary Formulas are unavailable because Tabular Reports have no grouping or aggregation, and Cross-Block Formulas are exclusively available in Joined Reports only."

Question 11

What are Dashboards in Salesforce?

✅ Answer

A Dashboard is a visual display of report data using charts, graphs, tables, and metrics — giving a real-time snapshot of business performance in a single screen! 📊

📋 Key Dashboard Components

Component	Description
Dashboard Component	Individual visual widget (chart, gauge, table, metric)
Source Report	Every component is powered by a report
Dashboard Filter	Dynamically filter dashboard data
Running User	Whose data perspective the dashboard shows
Refresh	Manual or scheduled data refresh

✅❌ What Dashboards Control

✅Can have up to 20 components per dashboard
✅Supports Dynamic Dashboards — shows data per logged-in user
✅Can be subscribed to receive scheduled snapshots via email
❌Cannot display data without a source report
❌Cannot use Tabular or Joined Reports as source
❌Cannot show real-time data — based on last refresh

🎤 One-Line Answer for Interview

"A Dashboard in Salesforce visually displays report data through components like charts, gauges, tables, and metrics — each powered by a source report — with a maximum of 20 components per dashboard and no support for Tabular or Joined Reports as sources."

Question 12

How many Dashboards can be displayed on a Lightning Page?

✅ Answer

In Salesforce, you can display up to 3 Dashboards on a single Lightning Home Page or App Page! 📊

📋 Dashboard Display Limits

Where	Limit
Components per Dashboard	Max 20
Dashboards on Lightning Home Page	Max 3
Dashboards on App Page	Max 3
Dashboards on Record Page	❌ Not Supported
Dashboard Filters per Dashboard	Max 3

🔑 Key Points for Interviewer

🔥Max 3 dashboards per Lightning Page — most asked limit!
🔥Dashboards cannot be embedded on Record Pages — common trap!
💡For more than 3 — create a dedicated Lightning App Page with tabs
💡Always distinguish: components inside dashboard (20) vs dashboards on page (3)

🎤 One-Line Answer for Interview

"A maximum of 3 Dashboard components can be displayed on a single Lightning Home Page or App Page, while each individual dashboard can contain up to 20 components — and dashboards cannot be embedded directly on Record Pages."

Question 13

What are the different Dashboard Component Types?

✅ Answer

Salesforce Dashboards support 9 types of components — each designed to visualize data differently based on business need! 📊

📋 All Dashboard Components

Component	Best Used For	Example
Bar Chart	Comparing values across categories	Orders by Territory
Line Chart	Trends over time	Monthly Revenue Trend
Donut Chart	Parts of a whole (%)	Leads by Source
Pie Chart	Distribution breakdown	Cases by Priority
Funnel Chart	Pipeline stage progression	Opportunity Stages
Scatter Chart	Compare two numeric values	Revenue vs Discount %
Gauge	Progress toward a target	Revenue vs Monthly Target
Metric	Single key number/KPI	Total Orders This Month
Table	Detailed data in rows (max 10)	Top 10 Customers

🔑 Key Points for Interviewer

🔥Gauge is for target vs actual — most commonly asked component!
🔥Table component shows max 10 rows — very common interview trap!
💡Metric shows a single number — perfect for KPIs
💡Every component must have exactly one source report

🎤 One-Line Answer for Interview

"Salesforce Dashboards support 9 component types — Bar, Line, Donut, Pie, Funnel, Scatter, Gauge, Metric, and Table — each powered by a single source report, with Gauge being the go-to for target tracking and Table limited to 10 rows."

Question 14

What are the different Chart Types available in Reports?

✅ Answer

Salesforce Reports support 8 types of charts — available on Summary, Matrix, and Joined Reports only! 📊

📋 All Chart Types

Chart Type	Best Used For
Bar Chart	Comparing values across categories (horizontal)
Column Chart	Same as Bar but vertical orientation
Line Chart	Showing trends over time
Pie Chart	Percentage distribution
Donut Chart	Parts of a whole with center value
Funnel Chart	Pipeline/stage progression
Scatter Chart	Comparing two numeric measures
Combination Chart	Bar + Line together in one chart

✅❌ What Report Charts Control

✅Available on Summary, Matrix and Joined reports
✅Combination Chart — overlays two measures (Bar + Line) in one view
❌NOT available on Tabular Reports
❌Cannot add more than one chart per report
❌Column vs Bar — Column is vertical, Bar is horizontal — interview trap! 🔥

🎤 One-Line Answer for Interview

"Salesforce Reports support 8 chart types — Bar, Column, Line, Pie, Donut, Funnel, Scatter, and Combination — available only on Summary, Matrix, and Joined Reports with one chart per report, where Combination Chart is unique in overlaying two measures like Bar and Line together."

Question 15

What is Schedule Future Run in Reports?

✅ Answer

Schedule Future Run allows you to automatically run a report at a set time and email results to specified users — zero manual effort needed! ⏰📊

📋 Schedule Settings

Setting	Options
Frequency	Daily, Weekly, Monthly
Preferred Start Time	Time of day to run
Send To	Users, Roles, Groups (max 500 recipients)
Active Schedules	Max 1 per report

✅❌ What Schedule Future Run Controls

✅Supports Daily, Weekly, Monthly frequency
✅Can send to max 500 recipients
❌Joined Reports cannot be scheduled — very common trap! 🔥
❌Reports in My Personal Folders cannot be scheduled
❌Maximum 1 active schedule per report
❌Cannot send to external email addresses

🎤 One-Line Answer for Interview

"Schedule Future Runs automatically runs a report at Daily, Weekly, or Monthly frequency and emails results to up to 500 recipients — with key limitations that Joined Reports cannot be scheduled, reports must be in shared folders, and only one active schedule is allowed per report."

Question 16

What is the problem if I cannot see an Object while creating a new Report?

✅ Answer

If an object is not visible while creating a report, the most common reason is the Report Type doesn't exist or is not Deployed — or the user lacks Read permission! ❌📊

📋 All Possible Reasons

Reason	Explanation
No Report Type exists	Custom Report Type not created for that object
Report Type not Deployed	Status is still "In Development"
No Read Permission	Profile doesn't have Read access to that object
Report Type deleted	Admin deleted the Report Type
Standard Report Type disabled	Admin has hidden standard report types

🌍 Real World Example

At Ami Polymer, after creating a custom Molecule Tracking object — a user can't see it while building a report. Root cause: Report Type was created but left in "In Development" status. Fix: Change status to Deployed — object appears instantly! 🎯

🎤 One-Line Answer for Interview

"If an object is not visible while creating a report, the most likely causes are that the Custom Report Type does not exist, its status is still 'In Development' instead of 'Deployed', or the user's Profile lacks Read permission — with Report Type deployment status being the most common root cause."

Question 17

What is Running User in Dashboard?

✅ Answer

Running User is the user whose data access and permissions are used to display dashboard data — regardless of who is actually viewing the dashboard! 👤📊

📋 Running User Types

Type	Description
Specific User	Fixed user — everyone sees same data (that user's access)
Dynamic Dashboard	Running User = Logged-in user — everyone sees their own data

✅❌ What Running User Controls

✅Controls whose data access is used to display the dashboard
✅Only Admins can set or change Running User
❌If Running User is deactivated — dashboard breaks and shows no data 🔥
❌Non-admin viewers cannot change Running User

🎤 One-Line Answer for Interview

"Running User in a Salesforce Dashboard is the user whose data access determines what all viewers see — meaning everyone sees the same data regardless of their own permissions, with only Admins able to set it and a deactivated Running User causing the dashboard to show no data."

Question 18

What is a Dynamic Dashboard?

✅ Answer

A Dynamic Dashboard automatically sets the Running User to the logged-in user — so every user sees their own personalized data on the same dashboard! 🔄📊

📋 Dynamic vs Standard Dashboard

Feature	Standard Dashboard	Dynamic Dashboard
Running User	Fixed specific user	Logged-in user
Data Shown	Same for everyone	Personalized per user
Use Case	Leadership overview	Individual performance
Can be Scheduled?	✅ Yes	❌ No
Max per Org (Enterprise)	Unlimited	5 dashboards

🔑 Key Points for Interviewer

🔥Dynamic Dashboards cannot be scheduled — most common trap!
💡Limited by Salesforce Edition — Enterprise gets 5, Unlimited gets 10
💡Eliminates need to clone dashboards per team or user
💡Each user sees data based on their own OWD and sharing

🎤 One-Line Answer for Interview

"A Dynamic Dashboard sets the Running User to the currently logged-in user so each viewer sees personalized data based on their own access — eliminating the need for multiple dashboards, but with the key limitation that Dynamic Dashboards cannot be scheduled for email delivery."

Question 19

What is Report Subscription in Salesforce?

✅ Answer

Report Subscription allows users to receive email notifications only when report data meets a specific condition — smarter than scheduled reports! 🔔📊

📋 Subscription vs Scheduled Report

Feature	Report Subscription	Scheduled Report
Trigger	Condition met	Fixed time
Notification	Only when condition is true	Every scheduled run
Set by	Any user (for themselves)	Admin/Report Manager
Condition Based	✅ Yes	❌ No
Max per user	5 subscriptions	1 per report

✅❌ What Report Subscription Controls

✅Sends email only when condition is met
✅Users can subscribe themselves without Admin help
❌Max 5 subscriptions per user — very commonly asked! 🔥
❌Joined Reports cannot be subscribed
❌Cannot send to external email addresses

🎤 One-Line Answer for Interview

"Report Subscription allows users to receive email notifications only when report data meets a specific condition — with a maximum of 5 subscriptions per user — making it smarter and more targeted than scheduled reports which run regardless of data conditions."

Question 20

What is a Cross Filter in Reports?

✅ Answer

A Cross Filter allows you to filter report results based on the presence or absence of related child object records — without adding child fields to the report! 🔍📊

📋 Cross Filter Options

Option	Meaning	Example
With	Show records that HAVE related child records	Accounts WITH Opportunities
Without	Show records that DO NOT have related child records	Accounts WITHOUT Opportunities

✅❌ What Cross Filter Controls

✅Supports "With" and "Without" conditions
✅Can add subfilters on the child object fields
✅Up to 3 Cross Filters per report
❌NOT available on Tabular Reports
❌Cannot cross filter on unrelated objects
❌Does not add child fields to report columns — filter only

🌍 Real World Example

At Ami Polymer, find all Accounts with NO Orders this quarter — potential at-risk customers! Cross Filter: Accounts WITHOUT Orders + Subfilter: Order Date = This Quarter. Instant at-risk customer list for follow-up! 🎯

🎤 One-Line Answer for Interview

"A Cross Filter in Salesforce Reports filters results based on the presence or absence of related child records using 'With' or 'Without' conditions — such as Accounts Without Opportunities — with a maximum of 3 cross filters per report and support for additional subfilters on child object fields."

Question 21

What is an Analytical Snapshot?

✅ Answer

An Analytical Snapshot runs a report on a schedule and saves results as records into a custom object — enabling historical trend analysis over time! 📸📊

📋 How Analytical Snapshot Works

Component	Description
Source Report	Must be a Tabular Report
Target Object	Custom Object where snapshot data is stored
Field Mapping	Maps report columns to target object fields
Schedule	Daily, Weekly, or Monthly
Max Rows	2000 rows per snapshot run

✅❌ What Analytical Snapshot Controls

✅Captures point-in-time report data as records
✅Enables historical trend analysis not possible with live reports
✅Stored data can be used to build trend reports and dashboards
❌Source report must be Tabular — most common interview trap! 🔥
❌Cannot capture more than 2000 rows per snapshot run
❌Does not update existing records — creates new records each run

🌍 Real World Example

At Ami Polymer, track how pipeline value changes every month: Create Tabular Report (Open Opportunities + Amount) → Custom Object (Pipeline Snapshot) → Analytical Snapshot runs every Month End → Build trend report on snapshot data. Historical pipeline data preserved forever! 🎯

🎤 One-Line Answer for Interview

"An Analytical Snapshot runs a Tabular Report on a schedule and saves results as records in a custom object — enabling historical trend analysis with a maximum of 2000 rows per run, with the strict requirement that the source report must always be Tabular."