I've got a rather annoying bug with Pivot tables. My Pivot table is as follows:
Activitygroups, with activities. These have locations and within locations rooms. These rooms have the metric i'm showing. This is working just fine as you can see with row totals and column totals working.
The issue only arises when I want to filter by a single location. As I said these locations have multiple rooms. These will still show so it still has values I want to see totalled at the end of the row.
Screenshot:
Sadly this isn't working which is annoying since I have to add by hand to see how much this location's rooms all add up to.
Is this an intended feature? I doubt it.
{
"browser-info": {
"language": "en-GB",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:122.0) Gecko/20100101 Firefox/122.0",
"vendor": ""
},
"system-info": {
"file.encoding": "Cp1252",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "17.0.6+10",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "17.0.6",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "17.0.6+10",
"os.name": "Windows Server 2019",
"os.version": "10.0",
"user.language": "en",
"user.timezone": "Europe/Berlin"
},
"metabase-info": {
"databases": [
"h2",
"sqlserver"
],
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MariaDB",
"version": "10.11.2-MariaDB"
},
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.7.10"
}
},
"run-mode": "prod",
"version": {
"date": "2024-02-22",
"tag": "v0.48.7",
"hash": "c192db1"
},
"settings": {
"report-timezone": "Europe/Amsterdam"
}
}
}
