Scatter Plot Chart

A scatter plot is a two-dimensional graph that uses dots to show the relationship between two different variables.

A Scatter Plot is a two-dimensional visualization that places dots at coordinates defined by two numeric variables—one on the X-axis and one on the Y-axis. Scatter plots are ideal for revealing correlation, clusters, outliers, and distribution patterns across large numbers of data points without regard to time.

Best use case:

• Displaying the relationship (positive/negative/none) between two quantitative variables.

Variations:

• Bubble Plot (3D) – Adds a third variable via bubble size.

• Density Plot (2D) – Emphasizes point density to handle heavy overplotting.

Apply Scatter Plot Properties to a View

1. On the Design page, select Scatter Plot.

2. Assign fields:

   • X-Axis (Measure) with Aggregation = None

   • Y-Axis (Measure) with Aggregation = None

3. (Optional) Add a category/color field via legend if supported.

4. Open Chart Properties to configure appearance and behavior.

Important: Scatter Plot requires Measures with Aggregation = None on both axes. Example: X = Experience (None), Y = Salary (None).

Properties

General Settings

• Exclude Global Filter – Ignore report-level filters for this View.

• Show Data Label – Display labels at point locations (use selectively to avoid clutter).

View Filter

• Filter – Apply conditions to subset the data (e.g., show a single department or range of values).

Note: View filters are applied after the View is added to the report.

Primary Value Axis (applies to both axes where configurable)

• Title – Set axis title (e.g., Experience (Years), Salary).

• Axis Label – Show/hide tick labels.

• Format Type – None, Auto, Percent, Thousand, Lacs, Crore, Million, Billion, Trillion, Quadrillion.

• Currency Type – None, Rupees, Euro, Pound, USD, Yen, Cent.

• Precision – Decimal places (up to 5).

Insights

• Text – Add contextual notes; highlight with asterisks (e.g., Top-right cluster, 75%).

• Font Size – Adjust annotation size.

• Font Color – Choose text color.

• Text Align – Left / Right / Centre.

• Position – Bottom / Right.

Notes & Best Practices

• Aggregation = None: Ensure both X and Y are raw measures (no aggregation) to plot individual points.

• Overplotting: For dense datasets, sample data, use transparency (if available), or switch to Density Plot.

• Scaling: If one variable dominates, consider log scaling (if available) or normalize upstream.

• Labels: Prefer tooltips over persistent labels to avoid overlap; enable Show Data Label sparingly.

• Outliers: Investigate extreme points—they can strongly influence perceived correlation.

Example Workflow

1. Map X = Experience (None), Y = Salary (None).

2. Add Filter = Department = Sales.

3. Set Axis Title and Format Type = Thousand for Salary; Precision = 0.

4. Add Insights: “Positive correlation; senior staff earn more”.

5. Save the View.