Variable Field Filter "Between", "Previous Month" vs. Pivot Showing Different Result

Hey Metabase Support team,

Question 1
I was wondering if you know why both

  1. Variable Field Filter "Between" vs. Pivot and
  2. Variable Field Filter "Previous Month" vs. Pivot

are showing different result.

Please see the screenshot below for an example of Variable Field Filter "Between" vs. Pivot. For more context, I am using the same data source (the same exact columns, group by and table).

Question 2
When using "Previous Month", and let's say that today is April 7 2022, does "Previous Month" mean March 1 2022 to March 31 2022?

Thank you!

Screenshot mentioned above

Hi @christian-wiloejo
Post "Diagnostic Info" from Admin > Troubleshooting.
Latest release is 0.42.4: https://github.com/metabase/metabase/releases
Try looking in your database query log to see the difference in queries.

Here you go:

{
"browser-info": {
"language": "en-US",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.88 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.14.1+1",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.14.1",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.14.1+1",
"os.name": "Linux",
"os.version": "4.14.268-205.500.amzn2.x86_64",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"postgres",
"redshift",
"h2"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "10.18"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.23"
}
},
"run-mode": "prod",
"version": {
"date": "2022-04-07",
"tag": "v0.42.4",
"branch": "release-x.42.x",
"hash": "7c3ce2d"
},
"settings": {
"report-timezone": "US/Eastern"
}
}
}

@christian-wiloejo
Yeah, so are you still having the same problem now, after you have upgraded?
And what do you see in the database query logs?