eschutho commented on issue #20349:
URL: https://github.com/apache/superset/issues/20349#issuecomment-1155732291

   @jbvsmo I found this post which looks related to this issue: 
https://community.dremio.com/t/unable-to-group-by-date-trunc/7953
   
   @rusackas I think it makes sense to investigate this further and whether 
it's indeed a fix that's needed on our side or Dremio, but I think as as 
workaround you should be able to create a calculated column on your dataset for 
`DATE_TRUNC('day', "OperationDate")` and give it a new name and then use that 
new column for your dimension/group by (you can use the original column in your 
time dimension). When trying that my query now looks like this one, which 
matches what looks to be the fix for Dremio:
   
   
![_DEV__Explore_-_Untitled_Query_1_06_14_2022_14_17_27](https://user-images.githubusercontent.com/5186919/173692767-a5ebab20-1e20-4314-a2ef-3ad3ec65da14.png)
   


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

To unsubscribe, e-mail: [email protected]

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