You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2020/06/03 06:07:40 UTC

[GitHub] [incubator-superset] sedhha opened a new issue #9974: How to add greater than filter in apache superset?

sedhha opened a new issue #9974:
URL: https://github.com/apache/incubator-superset/issues/9974


   
   Has superset changed its folder locations and interface? From a youtube tutorial, I found these options available in filter box:
   ![image](https://user-images.githubusercontent.com/36355685/83600250-c86f5c80-a58b-11ea-8e90-22c9de9ae1b8.png)
   But what my filter looks like is:
   ![image](https://user-images.githubusercontent.com/36355685/83600336-fb195500-a58b-11ea-853a-003ac6f48a7a.png)
   
   
   I want to apply a filter box which gives me flexibility to apply a filter over ranges. For example, this is my table:
   ![image](https://user-images.githubusercontent.com/36355685/83600423-3025a780-a58c-11ea-8354-a2eaa583ccf1.png)
   
   I want to add a filter where it should display only those table results where videos>=100 and videos<=10000. Although filter allows me to select multiple value but what it doesn't allow me is to apply ranges, and as you know there are so many values between these two ranges, it gets very inefficient to apply these filters.
   
   I tried to apply the filter as shown below:
   ![image](https://user-images.githubusercontent.com/36355685/83601395-2735d580-a58e-11ea-8eac-3d71ee20228e.png)
   ![image](https://user-images.githubusercontent.com/36355685/83601435-37e64b80-a58e-11ea-80b5-5305fc83288f.png)
   ![image](https://user-images.githubusercontent.com/36355685/83601480-50566600-a58e-11ea-93fa-69c4187580ba.png)
   But how it works is this way:
   ![image](https://user-images.githubusercontent.com/36355685/83601525-63693600-a58e-11ea-9a83-28d7caa0b52a.png)
   When we look at time filter:
   ![image](https://user-images.githubusercontent.com/36355685/83601599-84318b80-a58e-11ea-826a-5da1a5f9ecd7.png)
   It works well and offers tons of customization, I was just curious if we can dynamically filter time then why not other values. Please do let me know if you have something for this.
   
   **Additional context**
   Add any other context or screenshots about the feature request 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:
users@infra.apache.org



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

[GitHub] [incubator-superset] stale[bot] commented on issue #9974: How to add greater than filter in apache superset?

Posted by GitBox <gi...@apache.org>.
stale[bot] commented on issue #9974:
URL: https://github.com/apache/incubator-superset/issues/9974#issuecomment-687656138


   This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue `.pinned` to prevent stale bot from closing 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

[GitHub] [incubator-superset] stale[bot] commented on issue #9974: How to add greater than filter in apache superset?

Posted by GitBox <gi...@apache.org>.
stale[bot] commented on issue #9974:
URL: https://github.com/apache/incubator-superset/issues/9974#issuecomment-734495268


   This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue `.pinned` to prevent stale bot from closing 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

[GitHub] [incubator-superset] lozbrown commented on issue #9974: How to add greater than filter in apache superset?

Posted by GitBox <gi...@apache.org>.
lozbrown commented on issue #9974:
URL: https://github.com/apache/incubator-superset/issues/9974#issuecomment-748987321


   @junlincc 
   Any chance this might be possible soon?
   


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

[GitHub] [incubator-superset] aussat edited a comment on issue #9974: How to add greater than filter in apache superset?

Posted by GitBox <gi...@apache.org>.
aussat edited a comment on issue #9974:
URL: https://github.com/apache/incubator-superset/issues/9974#issuecomment-654237965


   @sedhha Agree, this would be great if dynamic filters added to Superset. I am not sure if it works for your problem, but you can try to use CASE function to the range you need to filter. In order to do this, just add a new column in datasource editor with required SQL, then use this column in FIlter View.
   
   ```
   CASE
       WHEN condition1 THEN result1
       WHEN condition2 THEN result2
       WHEN conditionN THEN resultN
       ELSE result
   END;
   ```


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

[GitHub] [incubator-superset] aussat commented on issue #9974: How to add greater than filter in apache superset?

Posted by GitBox <gi...@apache.org>.
aussat commented on issue #9974:
URL: https://github.com/apache/incubator-superset/issues/9974#issuecomment-654237965


   Agree, this would be great if dynamic filters added to Superset. I am not sure if it works for your problem, but you can try to use CASE function to the range you need to filter. In order to do this, just add a new column in datasource editor with required SQL, 
   then use this column in FIlter View.
   
   ```
   CASE
       WHEN condition1 THEN result1
       WHEN condition2 THEN result2
       WHEN conditionN THEN resultN
       ELSE result
   END;
   ```


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

[GitHub] [incubator-superset] issue-label-bot[bot] commented on issue #9974: How to add greater than filter in apache superset?

Posted by GitBox <gi...@apache.org>.
issue-label-bot[bot] commented on issue #9974:
URL: https://github.com/apache/incubator-superset/issues/9974#issuecomment-637976049


   Issue Label Bot is not confident enough to auto-label this issue. See [dashboard](https://mlbot.net/data/apache/incubator-superset) for more details.


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

[GitHub] [incubator-superset] aussat edited a comment on issue #9974: How to add greater than filter in apache superset?

Posted by GitBox <gi...@apache.org>.
aussat edited a comment on issue #9974:
URL: https://github.com/apache/incubator-superset/issues/9974#issuecomment-654237965


   @sedhha Agree, this would be great if dynamic filters added to Superset. I am not sure if it works for your problem, but you can try to use CASE function to the range you need to filter. In order to do this, just add a new column in datasource editor with required SQL, 
   then use this column in FIlter View.
   
   ```
   CASE
       WHEN condition1 THEN result1
       WHEN condition2 THEN result2
       WHEN conditionN THEN resultN
       ELSE result
   END;
   ```


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

[GitHub] [incubator-superset] AsjadMahmood commented on issue #9974: How to add greater than filter in apache superset?

Posted by GitBox <gi...@apache.org>.
AsjadMahmood commented on issue #9974:
URL: https://github.com/apache/incubator-superset/issues/9974#issuecomment-693225092


   Any update how we can add  less than greater than filter in Filter Box so we can apply it on the dashboard, we do get to add these filters in other charts, but not in Filter Box


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

[GitHub] [incubator-superset] sedhha commented on issue #9974: How to add greater than filter in apache superset?

Posted by GitBox <gi...@apache.org>.
sedhha commented on issue #9974:
URL: https://github.com/apache/incubator-superset/issues/9974#issuecomment-654275680


   Oh amaing @aussat Thanks a lot will try this out.


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

[GitHub] [incubator-superset] aussat edited a comment on issue #9974: How to add greater than filter in apache superset?

Posted by GitBox <gi...@apache.org>.
aussat edited a comment on issue #9974:
URL: https://github.com/apache/incubator-superset/issues/9974#issuecomment-654237965


   @sedhha Agree, this would be great if dynamic filters added to Superset. I am not sure if it works for your problem, but you can try to apply CASE function to the range you need to filter. In order to do this, just add a new column in datasource editor with required SQL, then use this column in FIlter View.
   
   ```
   CASE
       WHEN condition1 THEN result1
       WHEN condition2 THEN result2
       WHEN conditionN THEN resultN
       ELSE result
   END;
   ```


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