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/04 17:41:20 UTC
[GitHub] [incubator-superset] malcomwilk opened a new issue #9987: SuperSet SQL Grouping Columns
malcomwilk opened a new issue #9987:
URL: https://github.com/apache/incubator-superset/issues/9987
Hi there I was wanting to figure out how to organize columns in a specific way in my chart/dashboard. So for instance I have one chart where I have a neat organization with statuses that are under a number to denote their placement in the assembly line of a production process. But I have another chart though where I don't have the column status numbers 0, 1, 2, and 3. I have similar status to the other chart, but not the "progress numbers." When I look in the "Query" section under "columns" I can't find a "progress" status to group this chart with. The other chart is similar to the image I provided is like the organized chart that I want to emulate. How do I make a specific element of my chart be grouped/associated with a specific status or grouping?
I should mention that I didn't create the data source, table, or schemas and I'm not sure how to access them either.
Any help would be greatly appreciated.
----------------------------------------------------------------
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] malcomwilk commented on issue #9987: SuperSet SQL Grouping Columns
Posted by GitBox <gi...@apache.org>.
malcomwilk commented on issue #9987:
URL: https://github.com/apache/incubator-superset/issues/9987#issuecomment-642270768
>
>
> You should probably ask the owner of the table/view to add/compute such a column.
> Alternatively, if you are allowed to add a new table to superset or to alter the definition of the existing one, you may add this column by yourself.
> You could add this column as a calculated column or go to superset and effectively perform a SELECT * on the source table in SQLLab and add the needed column there. Then you can register this table by clicking Visualize.
> In order to calculate the needed column, you need to refer to the docs of the DB. You may use a CASE statement here, or, if going via SQLLab, you may define a lookup table as CTE in advance that assigns the progress numbers to their descriptions. But this depends on the capabilities of your DB.
Thank you. I was able to pull it off. I'm still new to writing SQL related stuff.
----------------------------------------------------------------
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 #9987: SuperSet SQL Grouping Columns
Posted by GitBox <gi...@apache.org>.
issue-label-bot[bot] commented on issue #9987:
URL: https://github.com/apache/incubator-superset/issues/9987#issuecomment-639003130
Issue-Label Bot is automatically applying the label `#question` to this issue, with a confidence of 0.65. 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
[GitHub] [incubator-superset] malcomwilk closed issue #9987: SuperSet SQL Grouping Columns
Posted by GitBox <gi...@apache.org>.
malcomwilk closed issue #9987:
URL: https://github.com/apache/incubator-superset/issues/9987
----------------------------------------------------------------
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] rumbin commented on issue #9987: SuperSet SQL Grouping Columns
Posted by GitBox <gi...@apache.org>.
rumbin commented on issue #9987:
URL: https://github.com/apache/incubator-superset/issues/9987#issuecomment-640178255
You should probably ask the owner of the table/view to add/compute such a column.
Alternatively, if you are allowed to add a new table to superset or to alter the definition of the existing one, you may add this column by yourself.
You could add this column as a calculated column or go to superset and effectively perform a SELECT * on the source table in SQLLab and add the needed column there. Then you can register this table by clicking Visualize.
In order to calculate the needed column, you need to refer to the docs of the DB. You may use a CASE statement here, or, if going via SQLLab, you may define a lookup table as CTE in advance that assigns the progress numbers to their descriptions. But this depends on the capabilities of your DB.
----------------------------------------------------------------
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