Export to Excel from Pivot table

1

So i have this question:

image
image832×653 95.4 KB

And when i download to excel, my data in excel looks like this:
(I only got the totals column)

image
image445×503 11.7 KB

I would have expected that the export would have been something like this:

image
image833×713 121 KB

Is this a known bug?
I installed the latest version.

{
  "browser-info": {
    "language": "nl-NL",
    "platform": "Win32",
    "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "Cp1252",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.16.1+1",
    "java.vendor": "Eclipse Adoptium",
    "java.vendor.url": "https://adoptium.net/",
    "java.version": "11.0.16.1",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.16.1+1",
    "os.name": "Windows Server 2019",
    "os.version": "10.0",
    "user.language": "en",
    "user.timezone": "Europe/Paris"
  },
  "metabase-info": {
    "databases": [
      "postgres"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "14.5"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.5.0"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2023-02-19",
      "tag": "v0.45.3",
      "branch": "release-x.45.x",
      "hash": "070f57b"
    },
    "settings": {
      "report-timezone": "Europe/Brussels"
    }
  }
}
2

are you completely sure that the question is saved (you clicked the save button) before you download it?

You seem to be hitting this Exports of Pivot Table excludes some columns when question is unsaved · Issue #26614 · metabase/metabase · GitHub

3

Hi,
Indeed it was not saved, but in the way we work, that's normal.
We make the report without date filter.
The client then sets the filter and wants to export that, but they can't save it. (or they would have to save it somewhere else over and over again).

Glad to see it is a known bug.

4

Hi, I'm facing the exact same issue as you, it might be a side effect of this issue also: Exports of Pivot Table contains `pivot-grouping` when question is unsaved · Issue #15034 · metabase/metabase · GitHub
But still, it's a bit painful. Did you find a workaround in the meantime?

5

Only workaround is to save the question i'm afraid.

1 Like