zuzana-vej opened a new issue #11426:
URL: https://github.com/apache/incubator-superset/issues/11426


   The Series Limit dropdown in Superset Explore allows to limit the number of 
series when there are too many. However, it looks like the specified limit is 
not accurate. 
   The query generated from the chart looks correct, and running the query in 
SQL Lab gives the expected result - if limit is 5 items, all 5 items are 
showing up there. So the problem seem to be with the chart.
   
   ### Expected results
   
   Series Limit = 10 shows 10 results
   
   ### Actual results
   
   Setting Series Limit = 10 gave me 9 results when 10 series actually existed. 
In another case series limit = 10 gave 14 results.  Note I believe when using 
with time shift, the time shifted lines might not be counting to the total 
limit (regardless of how this case is actually handled, current behavior has 
issue). 
   
   #### Screenshots
   
   Example 1: Returned 14 series, while limit is set to 10.
   ![Screen Shot 2020-10-26 at 8 00 04 
AM](https://user-images.githubusercontent.com/61221714/97189554-f5eabb80-1761-11eb-92d3-e4ce306b6dcc.png)
   
   Example 2: Returned 6 series while limit it set to 5.
   ![Screen Shot 2020-10-26 at 8 00 29 
AM](https://user-images.githubusercontent.com/61221714/97189576-fc793300-1761-11eb-8322-76b6c1956d94.png)
   
   Example 3: Even when removing time shift comparisons, the result is 2 
series, while limit is set to 5. 
   ![Screen Shot 2020-10-26 at 8 20 44 
AM](https://user-images.githubusercontent.com/61221714/97191652-53800780-1764-11eb-9585-8ce6c9834ecc.png)
   
   
   #### How to reproduce the bug
   
   1. Go to Chart Explore, Line chart
   2. Click on Series and set the limit
   3. See how many results you actually get
   
   ### Environment
   
   (please complete the following information):
   
   - superset version: `master`
   
   ### Checklist
   
   - [ ] I have checked the superset logs for python stacktraces and included 
it here as text if there are 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.
   
   ### Additional context
   
   Add any other context about the problem here.
   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
[email protected]



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to