[GitHub] [incubator-superset] mistercrunch commented on issue #7831: Top 5 product on revenue basis issue in chart

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

mistercrunch commented on issue #7831: Top 5 product on revenue basis issue in chart
URL: https://github.com/apache/incubator-superset/issues/7831#issuecomment-510331997
 
 
   There's some SQL you can write to get to that exact result, probably using `UNION ALL` to union 3 different queries, one for each month. Each query will need some relative date filters.
   
   You can create a VIEW in the database and use that as a datasource, or author in SQL Lab and follow the visualize flow. 
   
   It's not super easy or intuitive, but it's doable.

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


With regards,
Apache Git Services

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