Trend not working - Group by a time field to see how this has changed over time

trying to get a trend on a daily metric and getting the
error: Group by a time field to see how this has changed over time

the date field is a creation timestamp in the data model.

please help

Hi @theo
Please post “Diagnostic Info” from Admin > Troubleshooting.
And which database you’re querying.

  "browser-info": {
    "language": "en-GB",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.121 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.4+11",
    "java.vendor": "AdoptOpenJDK",
    "java.vendor.url": "https://adoptopenjdk.net/",
    "java.version": "11.0.4",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.4+11",
    "os.name": "Linux",
    "os.version": "4.14.138-89.102.amzn1.x86_64",
    "user.language": "en",
    "user.timezone": "GMT"
  },
  "metabase-info": {
    "databases": [
      "mysql"
    ],
    "hosting-env": "elastic-beanstalk",
    "application-database": "postgres",
    "run-mode": "prod",
    "version": {
      "date": "2019-10-07",
      "tag": "v0.33.4",
      "branch": "release-0.33.x",
      "hash": "9559406"
    },
    "settings": {
      "report-timezone": "Europe/London"
    }
  }
}

querying mariaDB (10.3.8-MariaDB-log)

thanks :slight_smile:

@theo Version 0.33.4 is almost 1 year old. Latest release is 0.36.6

Ok so you think an update should fix this?

We’re definitely due one!

@theo
I cannot reproduce on 0.36.6 - fairly sure there were some fixes in 0.34.x that fixed some trend issues.

1 Like