[GitHub] [incubator-superset] zuzana-vej commented on issue #11426: Line chart series limit doesn't show correct result on chart

[GitBox <gi...@apache.org>]

zuzana-vej commented on issue #11426:
URL: https://github.com/apache/incubator-superset/issues/11426#issuecomment-743324235


   Yes, we determined it's not a bug. Here is when we found out of was happening and how to prevent it:
   When there is no sort metric, so if you run query with LIMIT 10, it can limit kind of randomly. If you add "advanced analytics" with offset, it basically results in 2 queries and since there is no sort metric and they are limited to 10 (or whatever you use) the returned results could mismatch so you might see more than 10 values in the final chart. 
   
   Easiest way to validate once you build your chart is to get the query and try to run it in SQL Lab. When we tried it without the sort metric, we could get different results different times the query is run. Adding the sort metric should fix the issue.


----------------------------------------------------------------
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:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org