florianmonfort opened a new issue #4929: Cannot group by other than strings URL: https://github.com/apache/incubator-superset/issues/4929 Make sure these boxes are checked before submitting your issue - thank you! - [ ] I have checked the superset logs for python stacktraces and included it here as text if any - [x] I have reproduced the issue with at least the latest released version of superset - [x] I have checked the issue tracker for the same issue and I haven't found one similar ### Superset version 0.24.0 ### Expected results Group by our ID column ### Actual results Can only select some specific columns in GROUP BY ### Steps to reproduce - Add the table; - Open table to create a slice; - Try to Group by ID column; Hi, I have a table with menu items from restaurants. In this table we added for each menu item the associated restaurant ID. So multiple rows can have the same associated "restaurant_id". So I am trying to get the average number of items per restaurant_id. But in GROUP BY, I cannot select that column:  However in "Not group by" that column appears as usable:  This might not be a bug at all but maybe just my lack of technical skills which means there is something I don't know about how DBs and SQL work 😅. I apologize in advance if that's the case, I just haven't figured out where to get an explanation anywhere else.
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
