Our Salesforce data source visualizes data from reports built in Salesforce (Enterprise, Unlimited, Developer, or Performance editions). You can create a custom Summary, Tabular or Matrix report by either building a new report from scratch or customizing an existing standard report. Joined reports are not supported.

Line, Column and Bar Charts: Grouped fields will be available as the X-Axis options, with summary fields as the Y-Axis options.

Leaderboards: Grouped fields will be available as the 'Labels' options and Summary fields as the corresponding 'Values'.

Number and Gauges: With only numerical data, they display values from just the summary fields. The value displayed will be the summarized metric (i.e. Sum, Avg, Min, Max) calculated based on all the records available within the report. For example, the metric displayed can be Sum of Total Sales Amount, Average Probability, Maximum Price, etc.

On all visualizations, the Record Count (number of items) summary metric will always be available for each grouped field within your report.

If you had a Salesforce report (either Summary or Matrix) with the following grouped and summary fields:

The report preview would look something like this:

You’ll then have the following options to build your dashboard widgets:

X-Axis options: Opportunity Owner, Stage
​Y-Axis options: Sum of Amount, Average Probability, Average Number of Employees, Record Count

Labels: Opportunity Owner, Stage
​Values: Sum of Amount, Average Probability, Average Number of Employees, Record Count

Metric: Sum of Amount, Average Probability, Average Number of Employees, Record Count