Data points shown incorrectly at data visualization

Bug reports
1

Hi!

I have different kind of measurements collected in time. When I visualize them, I get 2 incorrect data points put at the wrong value of the y axis. I checked the data itself but it has a smaller value. This is true for all measurements, 2 of these spikes are present at the exact same time. In the attached image you can see the dashboard and the value itself.

47
471674×1182 190 KB

{
  "browser-info": {
    "language": "en-GB",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.97 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.7+10",
    "java.vendor": "AdoptOpenJDK",
    "java.vendor.url": "https://adoptopenjdk.net/",
    "java.version": "11.0.7",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.7+10",
    "os.name": "Linux",
    "os.version": "4.4.0-177-generic",
    "user.language": "en",
    "user.timezone": "GMT"
  },
  "metabase-info": {
    "databases": [
      "h2",
      "mongo"
    ],
    "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": "2020-05-28",
      "tag": "v0.35.4",
      "branch": "release-0.35.x",
      "hash": "b3080fa"
    },
    "settings": {
      "report-timezone": null
    }
  }
}
2

Hi @kulovan
It’s very difficult to figure out what’s going on, without knowing all the settings and field values.
What is the actual returned type and value from the database?
How are you formatting the field - just with Style=Percent, or with Suffix or…?

You should also migrate away from H2 if you’re using Metabase in production:
https://www.metabase.com/docs/latest/operations-guide/migrating-from-h2.html

3

Thank you for your comment!

The actual value is a NumberDecimal in the database and it is returned like this. The formatting is carried out with Style=Percent, and I am dividing it with 100 to have the correct value. I am having the same issue with Temperature and for another dashboard where I use suffix only. The time is at the same place for all of these spikes.

40
401362×1252 166 KB

4

@kulovan By any chance, could it be that you’re not aggregating the time, so the values are summed?
There’s a little warning triangle in upper-right corner of the visualization on the question.
https://github.com/metabase/metabase/issues/11907 - upvote by clicking :+1: on the first post

5

@flamber you are totally right, this is the problem! Thank you for you support, I am really grateful! :slight_smile: