How to Build a KPI Dashboard in Salesforce

How to build a sales KPI dashboard in Salesforce

A dashboard only shows what its source reports show. Build the reports first. Joined reports and historical trend reports cannot be used as a dashboard source.

1. 1

   Pick five to eight KPIs

   Write each KPI as one sentence, such as "closed-won amount this quarter" or "open pipeline by stage". One KPI maps to one source report.

2. 2

   Build one report per KPI

   On the Reports tab, click New Report. Choose the report type, such as Opportunities. Add filters for the time range and stage, and group or summarize the field you want to track. Save each report in a shared folder.

3. 3

   Create the dashboard

   On the Dashboards tab, click New Dashboard, give it a name and choose a folder. The builder opens as a blank canvas.

4. 4

   Add a widget for each KPI

   Click + Widget, choose a widget type, and select the source report. Use a Metric for one key number, a Gauge for one number against a target range, a Chart for a trend or a split, and a Table for a short list such as the top deals.

5. 5

   Add dashboard filters

   Add a filter, such as owner, region or close date, so one dashboard can answer more than one question.

6. 6

   Choose who the dashboard runs as

   A dashboard can run as a specified user, so everyone sees the same data. It can also run as the logged-in user, which is a dynamic dashboard: each viewer sees only the records they can access. Dynamic dashboards cannot be refreshed on a schedule and cannot be subscribed to, so they must be refreshed by hand.

7. 7

   Share it

   Save the dashboard in a folder that your team can view. Add it to a Lightning app page or a Home page so the team sees it each day.

Sources: Trailhead: Data Analysis with Reports and Dashboards; Salesforce Developers: Taking Advantage of Dynamic Dashboards

The Challenge

Building effective KPI dashboards requires careful selection of chart types, metric calculations, target values, and visual thresholds. Many Salesforce dashboards end up as collections of basic charts that do not clearly communicate whether performance is on track. Configuring gauge charts, dynamic targets, and color-coded thresholds manually is time-consuming.

Or let Clientell AI do it

Clientell AI configures KPI-focused dashboard components with the right chart types, target lines, gauge thresholds, and conditional formatting for each metric. Dashboards clearly communicate performance against targets so leaders can spot issues at a glance.

How It Works

1. 1

   Define KPIs and targets

   Specify the key performance indicators you want to track, including the metric calculation, target values, acceptable ranges, and the audience for each dashboard.

2. 2

   AI configures dashboard

   Clientell AI selects the optimal component types (gauge, metric, bar, trend line) for each KPI and configures target values, threshold breakpoints, and conditional color coding.

3. 3

   Review visual layout

   Preview the dashboard layout and verify that each KPI component displays the correct metric, target, and color thresholds. Rearrange components or adjust visual settings as needed.

4. 4

   Deploy and share

   Publish the dashboard to the appropriate folders and set running user permissions. Configure scheduled refreshes to keep KPI data current for stakeholders.

Frequently Asked Questions

Can I set different color thresholds for different KPIs?

Yes. Each dashboard component can have its own threshold breakpoints and color ranges. For example, a pipeline coverage gauge might use green above 3x and red below 1x, while a win rate gauge uses different ranges.

Can KPI targets update dynamically by quarter?

You can configure KPI targets using custom fields or formula fields that reference quota or goal records, allowing targets to change automatically each period without manual dashboard edits.

How do I control who sees which dashboard?

Dashboard visibility is managed through folder permissions. You can share folders with specific roles, groups, or users. The running user setting controls whose data perspective the dashboard displays.

Which KPIs should a Salesforce sales dashboard show?

Start with the numbers your team already reviews: open pipeline, closed-won amount, number of deals by stage, and activity counts. Each one needs a source report. Add more only when someone will act on them.

What is the difference between a metric and a gauge widget?

A metric shows one key value. A gauge shows one value against a range you set, such as quota progress. Both need a summary value from a source report.

Can a Salesforce dashboard use any report?

No. Joined reports and historical trend reports cannot be used as a dashboard source report.

Related Automations