Hello Metabase Team,
For some reason, the other options like Multiply by, Prefix, Suffix etc is sometimes missing in version 0.44.
Hi @taleno.digital
Post "Diagnostic Info" from Admin > Troubleshooting.
I cannot reproduce, so I'm guessing it has something to do with how the field is detected, so include the output of /api/card/123, where 123 is the question ID.
@taleno.digital
I was not asking for the logs, I was asking for "Diagnostic Info" from Admin > Troubleshooting (not Logs)
And the metadata of the question, which you can see by going to the URL /api/card/123, where 123 is the question ID.
Sorry @flamber ! Here's the Diagnostic Info
{
"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/104.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.16+8",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.16",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.16+8",
"os.name": "Linux",
"os.version": "5.4.172-90.336.amzn2.x86_64",
"user.language": "en",
"user.timezone": "UTC"
},
"metabase-info": {
"databases": [
"snowflake",
"h2"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "13.4 (Ubuntu 13.4-4.pgdg18.04+1)"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.3.5"
}
},
"run-mode": "prod",
"version": {
"date": "2022-08-04",
"tag": "v0.44.0",
"branch": "release-x.44.x",
"hash": "d3700f5"
},
"settings": {
"report-timezone": "US/Pacific"
}
}
}
And the Metadata of the question:
{"description":null,"archived":false,"collection_position":null,"table_id":125,"result_metadata":[{"description":null,"semantic_type":null,"coercion_strategy":null,"unit":"quarter","name":"RESPONSE_SUBMITTED_DATE","settings":null,"field_ref":["field",3273,{"temporal-unit":"quarter","join-alias":"Dim Typeform Responses"}],"effective_type":"type/DateTime","id":3273,"display_name":"Dim Typeform Responses → Response Submitted Date","fingerprint":{"global":{"distinct-count":5200,"nil%":0.0},"type":{"type/DateTime":{"earliest":"2018-12-27T15:54:43-08:00","latest":"2022-08-17T11:05:59-07:00"}}},"base_type":"type/DateTime"},{"display_name":"Average of Response Opinion Scale","semantic_type":"type/Category","settings":null,"field_ref":["aggregation",0],"name":"avg","base_type":"type/Number","effective_type":"type/Number","fingerprint":{"global":{"distinct-count":7,"nil%":0.0},"type":{"type/Number":{"min":4.271845,"q1":4.361595749999999,"q3":4.68731025,"max":4.792683,"sd":0.19837973183890598,"avg":4.550647142857143}}}}],"creator":{"email":"","first_name":"","last_login":"2022-08-26T00:38:34.960933Z","is_qbnewb":false,"is_superuser":true,"id":2,"last_name":"","date_joined":"2022-06-29T08:44:56.565293Z","common_name":""},"can_write":true,"database_id":2,"enable_embedding":false,"collection_id":8,"query_type":"query","name":"Maintenance Avg. CSAT QoQ","last_query_start":"2022-08-30T02:06:55.58112Z","dashboard_count":1,"average_query_time":1227.5833333333333333,"creator_id":2,"moderation_reviews":[],"updated_at":"2022-08-30T02:06:56.459028Z","made_public_by_id":null,"embedding_params":null,"cache_ttl":null,"dataset_query":{"type":"query","query":{"source-table":125,"joins":[{"fields":"all","source-table":108,"condition":["=",["field",3478,null],["field",3265,{"join-alias":"Dim Typeform Forms"}]],"alias":"Dim Typeform Forms"},{"fields":"all","source-table":117,"condition":["=",["field",3483,null],["field",3325,{"join-alias":"Dim Typeform Fields"}]],"alias":"Dim Typeform Fields"},{"fields":"all","source-table":110,"condition":["=",["field",3479,null],["field",3274,{"join-alias":"Dim Typeform Responses"}]],"alias":"Dim Typeform Responses"}],"filter":["and",["=",["field",3271,{"join-alias":"Dim Typeform Responses"}],"number"],["time-interval",["field",3273,{"join-alias":"Dim Typeform Responses"}],-1,"year",{"include-current":true}]],"aggregation":[["avg",["field",3480,null]]],"breakout":[["field",3273,{"temporal-unit":"quarter","join-alias":"Dim Typeform Responses"}]]},"database":2},"id":242,"parameter_mappings":[],"display":"smartscalar","entity_id":"1otOM61supdMW0lFM-uhE","collection_preview":true,"last-edit-info":{"id":2,"email":"","first_name":"","last_name":"","timestamp":"2022-08-26T01:01:21.450639Z"},"visualization_settings":{"series_settings":{"avg":{"line.interpolate":"cardinal","color":"#509EE3"}},"graph.show_values":true,"graph.y_axis.auto_range":false,"graph.y_axis.min":5,"graph.y_axis.max":3.5,"graph.show_trendline":true,"graph.dimensions":["RESPONSE_SUBMITTED_DATE"],"graph.metrics":["avg"]},"collection":{"authority_level":null,"description":"3rd Party & Home Services","archived":false,"slug":"04__maintenance","color":"#509EE3","name":"04. Maintenance","personal_owner_id":null,"id":8,"entity_id":null,"location":"/3/","namespace":null},"parameters":[],"dataset":false,"created_at":"2022-08-26T01:01:21.432347Z","public_uuid":null}
@taleno.digital It looks like the field is being set as "Category" field type. Set it to "No semantic type" or one of the numeric types.
Go to this URL: /admin/datamodel/database/2/table/125/3480/general
1 Like
Thanks @flamber ! Is this a bug? Metabase not being able to scan the right field type?
@taleno.digital You are explicitly telling Metabase to use a semantic type, which causes problems in some areas, since that semantic type you have chosen is used for strings.
Metabase should not have auto-selected this semantic type for a numeric column, so quite sure it's something you have defined.