[GitHub] [incubator-superset] gauravjindal25 opened a new issue #7186: Chart on Customized view

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

gauravjindal25 opened a new issue #7186: Chart on Customized view
URL: https://github.com/apache/incubator-superset/issues/7186
 
 
   I have two tables - Customer_Master & Device_master joined on userid. When I run below query I get the relevant output. State wise count in table view on superset. However, when I change the visualization type to Bar chart it doesn't give any output. What could be the possible reason? Would appreciate if someone can help me resolve this issue.
   
   SELECT state AS state,
          SUM(count) AS `SUM(count)`
   FROM
     (select B.state as state,
             count(distinct A.userid) as count
      from Device_master A
      inner join Customer_master B on A.userid = B.userid
        AND STATE IN ('CA', 'TX', 'FL',   'NY', 'IL') group by 1) AS expr_qry
   GROUP BY state
   ORDER BY `SUM(count)` DESC
   LIMIT 1000;

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


With regards,
Apache Git Services

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