Cumulative count wrong calculation

Hi, why did the Cumulative count get two different results when grouped by day and month? Should not get the same total number of 6 (1+2+3) in the below example for August and for all days in August?


Hi @aramit
Post "Diagnostic Info" from Admin > Troubleshooting, and the database type you're querying.

Hi @flamber here is the diagnostic info: {
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:104.0) Gecko/20100101 Firefox/104.0",
"vendor": ""
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.15+10",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.15",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.15+10",
"os.name": "Linux",
"os.version": "5.4.0-1039-aws",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"postgres"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "13.4"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.3.2"
}
},
"run-mode": "prod",
"version": {
"date": "2022-06-27",
"tag": "v1.43.4",
"branch": "release-x.43.x",
"hash": "61cc28e"
},
"settings": {
"report-timezone": null
}
}
}

And this the database type :
"database": {
"name": "PostgreSQL",
"version": "13.4"
},

@aramit If you are using the Pro/Enterprise plan, then you should use the support email.

You are not getting different results. You are grouping by day in the first screenshot, where across the three rows in the table, it accumulate to 3. When grouping by month, then there's still three rows in the table, but since you are grouping by month, then it will just show a single line with the accumulated value, which is still 3.

Perhaps I'm misunderstanding what you're trying to do.