Trend not condiring most recent period

I’m using a Trend visualization but It’s not correct when showing the main figure. It’s not showing the most recent period.

This is data source

Data

And this is Trend visualization

Trend

Am I doing something wrong or is a bug?

This is my diagnostic info

{
  "browser-info": {
    "language": "en",
    "platform": "Linux x86_64",
    "userAgent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.138 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.6+10-LTS",
    "java.vendor": "Amazon.com Inc.",
    "java.vendor.url": "https://aws.amazon.com/corretto/",
    "java.version": "11.0.6",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.6+10-LTS",
    "os.name": "Linux",
    "os.version": "4.14.173-137.228.amzn2.x86_64",
    "user.language": "en",
    "user.timezone": "UTC"
  },
  "metabase-info": {
    "databases": [
      "redshift",
      "postgres"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "10.4"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.2.8"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2020-05-28",
      "tag": "v0.35.4",
      "branch": "release-0.35.x",
      "hash": "b3080fa"
    },
    "settings": {
      "report-timezone": "UTC"
    }
  }
}

Hi @aris_pg
Looking at your “data source” image, it looks like it’s a Pivot table, meaning you have more than 2 columns of data, so not sure if that is somehow confusing the Trend visualization. It shouldn’t.
There was an issue in earlier versions, where data needed to be sorted ascending order (yours is descending), but that was fixed.
I cannot reproduce on latest release 0.36.6

Thanks @flamber ! With sorting is working