Graph visualizations do not work if data is not grouped

Hi! I just started using Metabase a few days ago and have run into a strange problem. When I query data using the question builder (or native SQL query) and try to visualize it with a graph, the graph fails (tables work fine, but graphs just show as greyed out and I can't select any X or Y variables in the visualization settings).

However, when I group my data by some column, graphs work fine. Attached are screenshots of this problem. To start with, here's the working graph and working query:


And then, once the 'site' group by is removed, the broken graph and broken query:


This is true of all graphs, not just the bar graph. Non-graph visualizations, like table, description, and number work fine.

I am running Metabase on docker. Fresh install as of 4 days ago, running v.0.47.3. Diagnostic info included at end of post. Application database is running on postgres, and the data source is another postgres database.

No errors show in the server logs when this is happening - only API call is:
[3aa92cb1-6a60-4a82-846d-5bb28334d283] 2023-10-09T18:19:21+01:00 DEBUG metabase.server.middleware.log POST /api/dataset 202 [ASYNC: completed] 115.3 ms (10 DB calls) App DB connections: 1/15 Jetty threads: 2/50 (5 idle, 0 queued) (84 total active threads) Queries in flight: 1 (0 queued); postgres DB 2 connections: 0/5 (0 threads blocked).

Any thoughts on how to resolve this very much appreciated! Thank you!

Diagnostic info from admin tab:
{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.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.20.1+1",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.20.1",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.20.1+1",
"os.name": "Linux",
"os.version": "5.4.0-162-generic",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"h2",
"postgres"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "12.16 (Ubuntu 12.16-0ubuntu0.20.04.1)"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.5.4"
}
},
"run-mode": "prod",
"version": {
"date": "2023-10-03",
"tag": "v0.47.3",
"branch": "?",
"hash": "4202328"
},
"settings": {
"report-timezone": null
}
}
}

whoa interesting, can you reproduce with the sample dataset? I would suggest you upgrade to 47.4

Hey Luiggi,

Dropped the ball here on my reply, but anyway...

Confirmed, replicated on the sample dataset! I upgraded to 47.7 and am still experiencing the same problems.