getredash/redash

Outliers hovertext data label is not accurate

Open

#5,639 opened on Nov 1, 2021

View on GitHub
 (4 comments) (2 reactions) (0 assignees)Python (24,845 stars) (4,236 forks)batch import
Visualizationshelp wanted

Description

Issue Summary

For Chart Type Box, the Data Labels {{ column_name }} entry does not work as expected.

Steps to Reproduce

  1. Load a dataset with outliers and a Name column. In my example the dataset are the outputs of a couple functions with inputs 0 through 9, and the names are randomly generated.
  2. Visualize using Visualization Type Chart, Chart Type Box, enter the numeric column under Y Columns, and under the Data Labels field put {{ Name }} as instructed in the question mark hovertext.

The name which shows up on the hovertext for any outlier appears to always come from the last row associated to the boxplot data. In this case, the last row is labeled with the name Erik, so although that is not an outlier for either boxplot, every outlier is labeled Erik.

Screen Shot 2021-11-01 at 15 31 20

Technical details:

  • Redash Version: Version: 8.0.0+b32245 (a16f551e)
  • Browser/OS: google chrome Version 95.0.4638.54 (Official Build) (x86_64)
  • How did you install Redash: V8 self hosted from Redash official cloud images

Contributor guide

Tech stack
pythonjavascript
Domain
frontendbackend
Issue type
bug
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
fresh
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
mostly clear
Prerequisites
Basic understanding of Redash visualizationJavaScript
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
50
Research direction
The issue is with the box plot chart type where data labels for outliers incorrectly show the last row's name. Investigate the frontend code in the chart visualization module, likely in the file that handles plotting with plotly. Check how hover text is generated for outliers and ensure that the correct row data is mapped to each outlier point. Look for any aggregation logic that might be using the last value instead of per point data. The code for box plot may be in `client/app/visualizations/chart/plotly/` or similar. Verify the data transformation step where outlier points are extracted.