Numeric field type not working for native query

Get Help
1

DB - MySQL

I am performing a running calculation and in my inner query, I have added custom filters that are working if the field type is a category but for the numeric field the numeric filter is not filtering the query.

select date, status,sum(count(distinct id)) over (partition by status order by date)
from (select id, status, order_type, ordersubtype, orderamount, date
from x
and date >= '2022-02-21'
[[and {{order_type}}]]
[[and {{ordersubtype}}]]
[[and {{orderamount}}]]) y
group by date, status

The order_type and ordersubtype fields are working as expected but the orderamount field numerical field is not filtering results.

2

Hi @trialanderror101
Post "Diagnostic Info" from Admin > Troubleshooting.
I cannot tell which type of filter you have selected for the Field Filters, but they should not be Category if they are numeric.

3

@flamber For the numeric field, I have selected a numeric filter. The category filters are working fine but numeric isn't filtering.

Diagnostic Info -

{
  "browser-info": {
    "language": "en-IN",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.3 Safari/605.1.15",
    "vendor": "Apple Computer, 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": "5.4.0-1029-aws",
    "user.language": "en",
    "user.timezone": "Asia/Kolkata"
  },
  "metabase-info": {
    "databases": [
      "mysql",
      "h2"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "12.7"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.2.8"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2021-01-13",
      "tag": "v0.37.6",
      "branch": "release-x.37.x",
      "hash": "344e5e0"
    },
    "settings": {
      "report-timezone": "Asia/Calcutta"
    }
  }
}
4

@trialanderror101 You should upgrade immediately to a newer release. There are new filter options in 42:
https://github.com/metabase/metabase/releases

5

@flamber I updated the Metabase to the newer release although the numeric filter is still not working.

Diagnostic info -

{
"browser-info": {
"language": "en-IN",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.3 Safari/605.1.15",
"vendor": "Apple Computer, 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": "5.4.0-1029-aws",
"user.language": "en",
"user.timezone": "Asia/Kolkata"
},
"metabase-info": {
"databases": [
"mysql",
"h2"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "12.7"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.23"
}
},
"run-mode": "prod",
"version": {
"date": "2022-02-28",
"tag": "v0.42.2",
"branch": "release-x.42.x",
"hash": "d6ff494"
},
"settings": {
"report-timezone": "Asia/Calcutta"
}
}
}

6

@trialanderror101 There's Number filters on the dashboard now. Try to reproduce your problem with the Sample Database and provide screenshots and examples, so it is possible to reproduce for others.