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/07/08 13:08:56 UTC
[GitHub] [incubator-superset] orderr66 opened a new issue #10256: Compare selected data with 'other' bucket
orderr66 opened a new issue #10256:
URL: https://github.com/apache/incubator-superset/issues/10256
Hello there :) Is there anything like compare selected(filtered) data with rest(other) of data. ?
For example:
I want to compare count of users in Top 5 country with sum of user count in other countries ?
US ->2ml
UK ->1ml
..
Other - 10ml
**Describe alternatives you've considered**
For now I'm creating calculated column: country_other
For example:
CASE
WHEN country in (
select x.country from (
select country, COUNT(country ) as num from 'ex_table' GROUP BY country ORDER BY num DESC LIMIT 5
) as x )
THEN country
ELSE 'other'
END
Also I'm facing with subquery limit issue while using this approach.
Thankss!
**Additional context**
I'm using Druid as Datasource.
----------------------------------------------------------------
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] closed issue #10256: Compare selected data with 'other' bucket
Posted by GitBox <gi...@apache.org>.
stale[bot] closed issue #10256:
URL: https://github.com/apache/incubator-superset/issues/10256
----------------------------------------------------------------
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 #10256: Compare selected data with 'other' bucket
Posted by GitBox <gi...@apache.org>.
stale[bot] commented on issue #10256:
URL: https://github.com/apache/incubator-superset/issues/10256#issuecomment-687812631
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] issue-label-bot[bot] commented on issue #10256: Compare selected data with 'other' bucket
Posted by GitBox <gi...@apache.org>.
issue-label-bot[bot] commented on issue #10256:
URL: https://github.com/apache/incubator-superset/issues/10256#issuecomment-655508310
Issue-Label Bot is automatically applying the label `#question` to this issue, with a confidence of 0.66. Please mark this comment with :thumbsup: or :thumbsdown: to give our bot feedback!
Links: [app homepage](https://github.com/marketplace/issue-label-bot), [dashboard](https://mlbot.net/data/apache/incubator-superset) and [code](https://github.com/hamelsmu/MLapp) for this bot.
----------------------------------------------------------------
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