Grouping same dimension twicd


#1

I’m trying to group by year then month with the same date field but it seems like Metabase is only able to group results once. Is this a limitation or am I looking at it incorrectly?


#2

Not a limitation, you’re just doing it wrong :wink:
image

Grouping by month gives month-year by default.

Limitation is if you want a stacked bar chart with one stack for each year divided by month. For that, you’ll need to alias the column by converting the question to SQL.


#3

Go and upvote by clicking :+1: