I'm trying to use the 'Trend' visualisation on a SQLite database, but I'm getting an error back saying:
Group by a time field to see how this has changed over time
To get the result set for the viz, I've tried using both the GUI and the SQL approach. In both cases, I'm only grouping by the date -- the images below show the result set for each option, and the error message:
GUI Builder
SQL Builder
This works for the other database that I've tried (SQL Server and PostgreSQL), but appreciate that SQLite is a funny one
Metabase details:
"browser-info": {
"language": "en-GB",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36",
"vendor": "Google Inc."
"system-info": {
"file.encoding": "Cp1252",
"java.runtime.name": "Java(TM) SE Runtime Environment",
"java.runtime.version": "1.8.0_251-b08",
"java.vendor": "Oracle Corporation",
"java.vendor.url": "http://java.oracle.com/",
"java.version": "1.8.0_251",
"java.vm.name": "Java HotSpot(TM) Client VM",
"java.vm.version": "25.251-b08",
"os.name": "Windows 10",
"os.version": "10.0",
"user.language": "en",
"user.timezone": "Europe/London"
"metabase-info": {
"databases": [
"sqlite",
"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": {
"tag": "v0.43.4",
"date": "2022-06-27",
"branch": "release-x.43.x",
"hash": "61cc28e"
"settings": {
"report-timezone": null
Note that the H2 database is the sample database (and the viz works for that one, too). This Metabase instance is only for me hence why it's also using the H2 backend (which I'll change eventually)
Hi
@Bilbottom
You're seeing this issue - SQLite is different in a couple of areas:
https://github.com/metabase/metabase/issues/12388
- upvote by clicking
on the first post
Time to upgrade to Java 11:
https://www.metabase.com/docs/latest/operations-guide/java-versions.html
