Hello everyone, can anyone explain why the value in the cell in the pivot visualization is not the same as the detail data? This happens when I browse the detail data - by clicking on the option on the pivot value.
For example I select the number 283 in the pivot cell (blue square) . But when click detail, the number of rows is not the same (mentioned 294 rows) .
Is there something wrong with my pivot visualization settings?
flamber
September 1, 2022, 1:23pm
2
Hi @afifdevtest
Post "Diagnostic Info" from Admin > Troubleshooting.
And you are using Sum of some field, which is not the same as the amount of rows.
{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.5112.102 Safari/537.36 Edg/104.0.1293.70",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "Cp1252",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "17.0.4.1+1",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/ ",
"java.version": "17.0.4.1",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "17.0.4.1+1",
"os.name": "Windows Server 2016",
"os.version": "10.0",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"h2",
"sqlserver"
],
"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": "2022-07-29",
"tag": "v0.43.4.2",
"branch": "release-x.43.x",
"hash": "7809f82"
},
"settings": {
"report-timezone": null
}
}
}
flamber
September 1, 2022, 1:46pm
4
@afifdevtest Sum of a field doesn't mean the same thing as amount of rows.
Use the Sample Database to provide an example if you don't want to share your data.
Latest release is 0.44.2: https://github.com/metabase/metabase/releases/latest
And you should migrate away from H2 if you are using Metabase in production:
https://www.metabase.com/docs/latest/installation-and-operation/migrating-from-h2
actually it's using CountIf function , not Sum....
Is that has any difference ?
flamber
September 1, 2022, 2:26pm
6
@afifdevtest You are viewing the pickup_region=value, you are not viewing specific value you clicked on.