metabase / metabase

The simplest, fastest way to get business intelligence and analytics to everyone in your company :yum:
https://metabase.com
Other
38.55k stars 5.11k forks source link

Incoherent export with "Download full results" from pivot questions #30637

Closed marc-dll closed 1 year ago

marc-dll commented 1 year ago

Describe the bug

Downloading results from a modified question with pivot vizualization creates an export file with a "pivot-grouping" column but without the columns chosen as pivot.

To Reproduce

  1. Open an existing pivot question with an existing filter
  2. Modify said filter
  3. Run the question by clicking the "Play" button
  4. Get a .csv or .xslx export with
  5. Open the file with LibreOffice or equivalent, it has a pivot-grouping column and the columns chosen in vizualization do not appear

Expected behavior

We should have an export coherent with the raw results

Logs

No response

Information about your Metabase installation

{
  "browser-info": {
    "language": "fr",
    "platform": "Linux x86_64",
    "userAgent": "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/112.0",
    "vendor": ""
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.18+10-post-Ubuntu-0ubuntu120.04.1",
    "java.vendor": "Ubuntu",
    "java.vendor.url": "https://ubuntu.com/",
    "java.version": "11.0.18",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.18+10-post-Ubuntu-0ubuntu120.04.1",
    "os.name": "Linux",
    "os.version": "5.4.0-146-generic",
    "user.language": "en",
    "user.timezone": "Europe/Paris"
  },
  "metabase-info": {
    "databases": [
      "h2",
      "mysql"
    ],
    "hosting-env": "unknown",
    "application-database": "mysql",
    "application-database-details": {
      "database": {
        "name": "MariaDB",
        "version": "10.3.38-MariaDB-0ubuntu0.20.04.1"
      },
      "jdbc-driver": {
        "name": "MariaDB Connector/J",
        "version": "2.7.6"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2023-04-28",
      "tag": "v0.46.2",
      "branch": "release-x.46.x",
      "hash": "8967c94"
    },
    "settings": {
      "report-timezone": null
    }
  }
}

Severity

Annoying

Additional context

No response

paoliniluis commented 1 year ago

duplicate of https://github.com/metabase/metabase/issues/26614