[GitHub] [incubator-superset] malcomwilk commented on issue #9987: SuperSet SQL Grouping Columns

[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