Is it possible to create a similar grouping for dates as shown in the image below for dashboard?
Hi @ghwr
Currently not without SQL (and a lookup table if you need a dropdown, otherwise it needs to be text input)
See the issue comments for a workaround:
https://github.com/metabase/metabase/issues/6583 - upvote by clicking 
on the first post
The issue is from 2017, any update for this ? Because if we could do the dynamic aggregation, it would be a game changer in our dashboard.
@kadekjati Metabase was originally a team with a handful people. Only until recently have we grown.
There are open feature requests from 2015.
You can see the roadmap here: https://www.metabase.com/roadmap/
Thank you for your swift reply! I'll check out the mentioned issue.