metabase / metabase/metabase

Offer a way to group by Day-Month of Year

Open
#61,533 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

.Project candidate Querying/Notebook Querying/Remapping Type:New Feature
Dominant language
Clojure
Stars
49.3k
Forks
6.8k
Avg merge
1d 13h
Merged PRs (30d)
653

Description

**Is your feature request related to a problem? Please describe.**

Currently there is no straight forward way to plot Year comparisons like 2024 vs 2025 via the Query Builder

Image

**Describe the solution you'd like**
I would like a group by option as "Day-Month of Year"

**Describe alternatives you've considered**
You can still achieve this using Custom Columns:

For example lets say I have a date, you can extract the month, then day and concat each:

Month - monthName(month([Created At]))
Day - day([Created At])
Month-Day - concat([Month], "-", [Day])

Image

Then use that new column as your group by:

Image

The only tricky part is that since this is now a text the order will be of course based on text. So you should still keep the date as a column in the group by and use it only for ordering purposes. Then only visualize the Month-Day

**How important is this feature to you?**
Would be a nice to have

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start from the Query Builder's existing group-by date options and the custom-column workaround described in the issue. Determine how a Day-Month of Year grouping should be represented and ordered, then verify that it supports year-over-year plots without requiring concatenated custom columns.

Written by the indexing model from the issue text.

Assessment

Tech stack
clojure
Domain
data-visualization
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.