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


   I know that superset has a close connection with time series, but if I do 
not need such attribute and set is_timeseries = false, the box plot will be a 
flat line. 
   Instead, if I need other attributes to series data, such as customers names 
or countries( columns in the dataset) how can I replace time series to other 
attributes? For example, I plan to create a new control panel like **Entity** 
and use this panel to replace time panel (**time range and time column**). This 
may be very similar to **Tableau's detail panel**.
   
   
      ` SELECT region AS region, year AS __timestamp, sum(`SP_POP_TOTL`) AS 
`sum__SP_POP_TOTL` 
       FROM wb_health_population INNER JOIN (SELECT region AS region__, 
sum(`SP_POP_TOTL`) AS mme_inner__ 
       FROM wb_health_population 
       WHERE year >= STR_TO_DATE('1960-01-01 00:00:00.000000', '%Y-%m-%d 
%H:%i:%s.%f') AND year <= 
       STR_TO_DATE('2020-07-29 08:20:11.000000', '%Y-%m-%d %H:%i:%s.%f') GROUP 
BY region ORDER BY mme_inner__ 
       DESC 
       LIMIT 25) AS anon_1 ON region = region__ 
       WHERE year >= STR_TO_DATE('1960-01-01 00:00:00.000000', '%Y-%m-%d 
%H:%i:%s.%f') AND year <= 
       STR_TO_DATE('2020-07-29 08:20:11.000000', '%Y-%m-%d %H:%i:%s.%f') GROUP 
BY region, year ORDER BY 
      `sum__SP_POP_TOTL` DESC 
       LIMIT 50000`
   As you can see, SQL queries years, what I want is to make SQL queries other 
attributes.
   I think what I should rewrite is viz.py and boxplot control panels. But in 
the viz.py, I didn't find where I can replace time series and in the control 
panels, I did not find where to delete the time panel. 
   
   Thanks!


----------------------------------------------------------------
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:
[email protected]



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to