I needed to achieve something similar and I ended up doing the following:

1. Create a view in the database (I'm using MySQL) that uses the desired GROUP BY statement

2. Create a dataset in Superset based on that view

3. Create a chart based on that dataset