[GitHub] [incubator-superset] lanyusea opened a new issue #11604: QUESTION: how could I not group data by the DATETIME value?

Fri, 06 Nov 2020 01:23:45 -0800 


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


   I have my data like that: `test date` `frame index` `test dataset` and the 
values
   
   
![image](https://user-images.githubusercontent.com/2766729/98344761-ad2ede80-204e-11eb-8741-b6585aaa8b3b.png)
   
   
   and it can be successfully updated
   
![image](https://user-images.githubusercontent.com/2766729/98345103-2cbcad80-204f-11eb-9247-10b03a6a890b.png)
   
   
   but the result looks really strange:
   
![image](https://user-images.githubusercontent.com/2766729/98345502-b66c7b00-204f-11eb-8afa-69526ca297b9.png)
   
   The `view query` is 
   ``` sql
   SELECT `Dataset` AS `Dataset`,
         `Date` AS __timestamp,
         AVG(`RPE`) AS `AVG(RPE)`
   FROM database.my_test
   GROUP BY `Dataset`,
         `Date`
   ORDER BY `AVG(RPE)` DESC
   LIMIT 50000;
   ```
   
   and the `view results` is 
   
![image](https://user-images.githubusercontent.com/2766729/98345802-1e22c600-2050-11eb-990f-9d5ec3286089.png)
   
   I relealize the problem may be caused by `GROUP BY Date` but it seems to be 
a default selection I cannot withdraw. (or I don't know how)
   
   What I expect is it samples data with same `PatchSet` and different 
`FrameIndex` then do the box plot.
   
   So I'm wondering if there is any way I can achienve this kind of 
virtualization?


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