Loading
Salesforce now sends email only from verified domains. Read More

How To Merge 2 Different Scatter Plots

Publish Date: Apr 21, 2025
Task

How to merge 2 different scatter plots

Merge 2 scatter slots like the following:
User-added image
User-added image

into 1 scatter plot 
User-added image

Steps
1. Go to Data source page
2. Drag [Orders] to the [Orders] in campus to union by itself
3. Create following calculations
X:
IF ATTR([Table Name])='Orders' THEN MAX([Discount]) ELSE AVG([Quantity]) END
Y:
IF ATTR([Table Name])='Orders' THEN SUM([Profit]) ELSE SUM([Sales]) END
4. Drag [Y] to [Rows], [X] to [Columns], [Region] to [Color], [Table Name] to [Shape]
Additional Resources
For other worksheets using same data source, Please follow steps below:
1. drag [Table Name] to [Filter]
2. select 'Orders'
3. right click on [Table Name] in [Filter] > Add to context
Knowledge Article Number

001456924

Attachments

DualScatterPlots.twbx

1324 KB

 
Loading
Salesforce Help | Article