[GitHub] [superset] vamruta commented on issue #6099: Dashboard conditional filter on numbers (group by)

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

vamruta commented on issue #6099:
URL: https://github.com/apache/superset/issues/6099#issuecomment-1095062416

   > > > I also think that it will be a great feature, I'm trying to develop it by my own, but I'm finding some difficulties.
   > > > I think that a good shortcut to implement it is use the adhoc filter section of the ControlPanel as a chart.
   > > > The problem of having this kind of filters is that they affect to the query below the charts, adding new "groupbys" and having clauses...
   > > > If someone have an idea of how to do it, I'll love discuss it.
   > > 
   > > 
   > > I'm happy to discuss this - we may be able to help.
   > 
   > Hello @jsalvatore.
   > 
   > I finally found a solution for it. I attach some screenshots. Although I haven't done any PR because I think that it is an sloppy solution but useful. First, I added a section in the filter box chart: ![image](https://user-images.githubusercontent.com/64475023/96833242-63d07380-1440-11eb-9674-2bc285ef9685.png) ![image](https://user-images.githubusercontent.com/64475023/96833277-721e8f80-1440-11eb-9829-c6deb5ec64a1.png) After fill this form you'll have something like this. ![image](https://user-images.githubusercontent.com/64475023/96833363-967a6c00-1440-11eb-98ba-8019ac3d6416.png)
   > 
   > This filter will add a "having" clause in the SQL query of the chart that it is affecting.
   > 
   > I'm not sure how to share every change that have been done to get this, but if you or anyone is interested in know it, you can contact me and I'll try to find a way to share it (I prefer not upload the complete repo to github, for now).
   
   Hi  @avicenteg,  I highly apprecitate your work. So usefull. Can you please show me how to use ? My email is amrutavishwakarma58@gmail.com
   


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