Limit Temporal Buckets

Get Help
1

Hi -

The dates in my SQL Server data are defined as DATE and only contain Month, Day, Year. There is no time component. Metabase still defaults the group option to "Minute". I've been looking at the source code and trying to limit the number of temporal buckets available. The values could come from lots of files. The one that seems to make the most sense is DATE_TIME_UNITS in DateTime.jsx but I still get defaults of "Minute".

Do you have any suggestions on how to exclude the time options? In my use case, a default of "Month" makes the most sense.

Thanks,
Bob

2

Hi @rleroy
The default depends on fingerprinting (see workaround on how to update https://github.com/metabase/metabase/issues/18074), but the options was specifically shown to avoid not even having the options, which is worse (https://github.com/metabase/metabase/pull/20902).

3

Thanks for the quick reply. I know I'm slow so I don't see how that work-around applies. My fingerprints look right. Here's an example.

# id, created_at, updated_at, name, base_type, semantic_type, active, description, preview_display, position, table_id, parent_id, display_name, visibility_type, fk_target_field_id, last_analyzed, points_of_interest, caveats, fingerprint, fingerprint_version, database_type, has_field_values, settings, database_position, custom_position, effective_type, coercion_strategy, nfc_path, database_required
'8383', '2020-04-06 22:00:01', '2020-04-07 00:00:16', 'DatePeriod', 'type/Date', 'type/CreationDate', '1', NULL, '1', '0', '947', NULL, 'Date Period', 'normal', NULL, '2020-04-07 00:00:17', NULL, NULL, '{\"global\":{\"distinct-count\":36,\"nil%\":0.0},\"type\":{\"type/DateTime\":{\"earliest\":\"2017-03-01T00:00:00.000Z\",\"latest\":\"2020-02-01T00:00:00.000Z\"}}}', '4', 'date', 'list', '{\"time_enabled\":null}', '8383', '0', 'type/Date', NULL, NULL, '0'

It all looks like Metabase is setup for Date. Is there a way to have the buckets default to "Month"?

Thanks again!

4

@rleroy Post "Diagnostic Info" from Admin > Troubleshooting.

5 
{
  "browser-info": {
    "language": "en-US",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "Cp1252",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11+28",
    "java.vendor": "Oracle Corporation",
    "java.vendor.url": "http://java.oracle.com/",
    "java.version": "11",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11+28",
    "os.name": "Windows Server 2016",
    "os.version": "10.0",
    "user.language": "en",
    "user.timezone": "America/New_York"
  },
  "metabase-info": {
    "databases": [
      "sqlserver"
    ],
    "hosting-env": "unknown",
    "application-database": "mysql",
    "application-database-details": {
      "database": {
        "name": "MySQL",
        "version": "8.0.17"
      },
      "jdbc-driver": {
        "name": "MariaDB Connector/J",
        "version": "2.7.6"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2022-09-11",
      "tag": "v1.44.3-SNAPSHOT",
      "branch": "release-x.44.x",
      "hash": "add8e75"
    },
    "settings": {
      "report-timezone": "US/Eastern"
    }
  }
}
6

@rleroy You are using a custom build. If you are a Pro/Enterprise customer, then please use the support email.
Latest release is 45.1.

Your fingerprint says it's a type/DateTime.
You can follow the steps I've included in the description of https://github.com/metabase/metabase/issues/18074 to see how you reset fingerprints.

Issue created to avoid showing time options for DATE columns:
https://github.com/metabase/metabase/issues/27362 - upvote by clicking :+1: on the first post

7

Ok, thanks for your help!