[GitHub] [superset] kevin-struckhoff commented on issue #16128: Extra SQL in simple line chart query causing wrong results

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

kevin-struckhoff commented on issue #16128:
URL: https://github.com/apache/superset/issues/16128#issuecomment-895465955


   I got it to work by first creating new metrics in the dataset used by the report and removing the group by setting.
   
    Using a Sort/Order by clause is old habit for me, since 1991, because it's never been taken for granted. Until now, I've never seen a data analysis product not have an order by clause in the generated sql. 
   
   Thanks. Kevin 
   
       On Sunday, August 8, 2021, 6:18:05 AM PDT, kaspergaj ***@***.***> wrote:  
    
    
   
   
   How do you want it visualized?
   I think the x-axis in linecharts has to be dates, so the _timestamp should correspond to the time at meal_date with a pandas representation.
   What do you wish to achieve with the sort by column? Only show the highest 100 results?
   My guess is you can achieve your desired chart by removing meal_date in Group By and leaving it empy. Maybe also keeping the Sort By box empty.
   
   —
   You are receiving this because you authored the thread.
   Reply to this email directly, view it on GitHub, or unsubscribe.
   Triage notifications on the go with GitHub Mobile for iOS or Android.
     


-- 
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.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

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