Dynamic columns for select and groupby

Get Help
1

Hi all :slight_smile:

My company will be migrating from Chartio to Metabase and I would like to know if it is possible to make the charts flexible with dynamic columns next to SELECT or GROUP BY (similar to the field filters next to WHERE) as it is currently possible in Chartio.

The query would look like this :

SELECT {{dynamic_dimension}}, {{dynamic_metric}}
FROM table
WHERE {{field_filter}}
GROUP BY {{dynamic_dimension}}

Thanks for your help!

2

Hi @phcastets
Currently no, but there are workarounds for grouping for some database. See this and the referenced issues: https://github.com/metabase/metabase/issues/9875#issuecomment-635413462

3

Hi @flamber :slight_smile:

Thanks for the quick reply and link!!