search

metabase / metabase

The simplest, fastest way to get business intelligence and analytics to everyone in your company :yum:
https://metabase.com
Other
38.08k stars 5.05k forks source link

Drill thrus suggest time breakouts e.g. "See this day by hour" for `DATE` columns resulting in broken queries #33573

Open camsaul opened 1 year ago

camsaul commented 1 year ago

Bug since forever.

  1. New Question > Raw Data > Sample Dataset > People
  2. Summarize by Count
  3. Group by Birth Date > Day
  4. Zoom in a bit
  5. Click a value an click See this day by hour
  6. Query fails, because you cannot bucket a DATE column by hour. Dates don't have hours.

We should NOT be presenting this option for :type/Date columns, only for :type/DateTime columns.

image image
kamilmielnik commented 7 months ago

I can still reproduce this in master, 926b04a1d5.