Integer field not binning

Get Help
1

Hi all,

I've got a table where I want to summarize by age and have them grouped into 10 bins. Auto binning doesn't seem to be working and I'm unable to figure out how to add it manually.

image

image
image1886×713 23.5 KB

Any advice on how I can get binning to work? I can't see it available on other questions etc either?

Cheers,

Elijah

2

Hi @Elijah
Please post "Diagnostic Info" from Admin > Troubleshooting.

Can you go to Admin > Data Model > (db) > (table) > (field) gear-icon.
Then the URL should look like /admin/datamodel/database/1/table/4/123/general where 123 would be the field ID.

And then go to the URL /api/field/123, and include the output here (you can redact connection details).

3

Hi Flamber.

Find the requested information below! Hope that's right. :slight_smile:

{
  "browser-info": {
    "language": "en-US",
    "platform": "Win32",
    "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.82 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "Cp1252",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.11+9",
    "java.vendor": "AdoptOpenJDK",
    "java.vendor.url": "https://adoptopenjdk.net/",
    "java.version": "11.0.11",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.11+9",
    "os.name": "Windows Server 2012 R2",
    "os.version": "6.3",
    "user.language": "en",
    "user.timezone": "Australia/Perth"
  },
  "metabase-info": {
    "databases": [
      "firebird"
    ],
    "hosting-env": "unknown",
    "application-database": "h2",
    "application-database-details": {
      "database": {
        "name": "H2",
        "version": "1.4.197 (2018-03-18)"
      },
      "jdbc-driver": {
        "name": "H2 JDBC Driver",
        "version": "1.4.197 (2018-03-18)"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2021-08-17",
      "tag": "v0.40.3",
      "branch": "release-x.40.x",
      "hash": "c82665c"
    },
    "settings": {
      "report-timezone": null
    }
  }
}

And the field metadata:

> {"description":null,"database_type":"INTEGER","semantic_type":"type/Quantity","table_id":123,"coercion_strategy":null,"table":{"description":null,"entity_type":"entity/GenericTable","schema":null,"db":{"description":null,"features":["full-join","basic-aggregations","standard-deviation-aggregations","expression-aggregations","percentile-aggregations","foreign-keys","right-join","left-join","native-parameters","nested-queries","expressions","regex","inner-join","advanced-math-expressions"],"cache_field_values_schedule":"0 0 23 * * ? *","timezone":"Australia/Perth","auto_run_queries":true,"metadata_sync_schedule":"0 1 * * * ? *","name":"","caveats":null,"is_full_sync":true,"updated_at":"2021-09-20T16:58:06.742","details":{"host":"","port":,"db":"","user":"","password":"**MetabasePass**","additional-options":null,"ssl":true,"let-user-control-scheduling":true},"is_sample":false,"id":2,"is_on_demand":false,"options":null,"engine":"firebird","refingerprint":true,"created_at":"2021-08-26T14:55:29.813","points_of_interest":null},"show_in_getting_started":false,"name":"PATIENT","caveats":null,"updated_at":"2021-09-15T17:02:57.397","entity_name":null,"active":true,"id":123,"db_id":2,"visibility_type":null,"field_order":"alphabetical","display_name":"Patient","created_at":"2021-08-26T14:55:44.314","points_of_interest":null},"name":"AGE_BIRTHYEARS_TODAY","fingerprint_version":5,"has_field_values":"list","settings":null,"caveats":null,"fk_target_field_id":null,"dimensions":[],"updated_at":"2021-09-20T16:45:41.913","custom_position":0,"effective_type":"type/Integer","active":true,"parent_id":null,"id":1957,"last_analyzed":"2021-08-26T15:35:31.909","position":5,"visibility_type":"normal","preview_display":true,"display_name":"Age Birthyears Today","database_position":37,"name_field":null,"fingerprint":{"global":{"distinct-count":104,"nil%":0.0026},"type":{"type/Number":{"min":0.0,"q1":22.131123022055405,"q3":51.10946446109321,"max":107.0,"sd":19.453546189579658,"avg":37.41608181271305}}},"created_at":"2021-08-26T14:56:14.254","base_type":"type/Integer","points_of_interest":null}

Thanks for being willing to help.

4

@Elijah Everything looks correct, but I'm guessing it's a problem with the Firebird driver. Which driver repo and version are you using?

5

Hi Flamber,

I'm using this driver and version: https://github.com/evosec/metabase-firebird-driver/releases/tag/v1.4.0

6

@Elijah Okay, I don't know Firebird, so it's hard for me to know if this is a general problem with that driver.

7

No worries,

Thanks for your help. I'll try and solve my problem with SQL.