The distribution bar chart uses row limit that applies a limit to the end of a 
single query grouping by series and breakdown. Ideally there should be a limit 
on a subquery for the series groupby.

Here's an example using contribution, the results are limited to 10 rows so it 
looks like some states have all boys and 0 girls, showing incorrect data 
because it's getting truncated by the limit.
![image](https://user-images.githubusercontent.com/817955/45578359-e6d07a00-b835-11e8-9460-19861848c0f3.png)

When the fix is in, add a cypress test for the dist bar chart with series, 
breakdown, and limit 10.

- [x] I have checked the superset logs for python stacktraces and included it 
here as text if any
- [x] I have reproduced the issue with at least the latest released version of 
superset
- [x] I have checked the issue tracker for the same issue and I haven't found 
one similar


### Superset version
master

### Expected results
The limit applies to the number of series results that show up, and the 
breakdown of that series shows up and does not get limited.

### Actual results
The limit applies to all rows returned series and breakdown

### Steps to reproduce
Create a dist bar with a series and breakdown and add a low row limit



[ Full content available at: 
https://github.com/apache/incubator-superset/issues/5904 ]
This message was relayed via gitbox.apache.org for [email protected]

Reply via email to