Feature Request - Download Chart data include multiple series

dsmith · April 21, 2023, 5:26pm

I have a chart that uses data series from two different questions:

When I download the data for this chart from the dashboard, the resulting document only downloads the data for the primary data series:
Screenshot 2023-04-21 at 1.27.19 PM

If a chart on a dashboard displays multiple data series, the download data function should also download the data from all of the displayed data series into the resulting document.

Luiggi · April 24, 2023, 9:12pm

github.com/metabase/metabase

Embedded dashboards: "Download full results" only returns single question data column in cards containing multiple questions

opened 10:47AM - 10 Oct 19 UTC

melbings

Type:Bug Priority:P2 .Correctness Reporting/Export Embedding/Signed Reporting/Dashboards/Combined charts

**Describe the bug** Downloading "full results" to Excel, CSV or JSON from a ca…rd containing multiple questions only returns a single data column (apparently the data from the *first* question added to the card). **To Reproduce** Steps to reproduce the behavior: 1. Create a dashboard 2. Add a question containing timeline-related data (x = date, y = number) to the dashboard 3. Add a second question containing timeline-related data (x = date, y = number) to the card created in step 2 4. Click "Download full results" and choose any output format 5. See that the downloaded data only contains a single data column (probably that from the first question added in step 2) **Expected behavior** The downloaded data should contain data from both questions, each in its own column. **Screenshots** 1. Clicking "download full results" ![image](https://user-images.githubusercontent.com/15344864/66562109-311c4b80-eb5b-11e9-8284-69f4f4a9dbc9.png) 2. Seeing incomplete data ![image](https://user-images.githubusercontent.com/15344864/66562182-64f77100-eb5b-11e9-8a76-f2eca34dc65f.png) Raw CSV: ``` Date,Sum of Registrations 2018-10-01,1894 2018-11-01,743 2018-12-01,390 2019-01-01,1207 2019-02-01,645 2019-03-01,953 2019-04-01,750 2019-05-01,958 2019-06-01,676 2019-07-01,916 2019-08-01,807 2019-09-01,2767 2019-10-01,328 ``` **Information about your Metabase Installation:** You can get this information by going to Admin -> Troubleshooting. - Your browser and the version: Firefox 69.0.2 - Your operating system: Ubuntu 19.04 - Your databases: MySQL 5.7 - Metabase version: 0.33.4 - Metabase hosting environment: Docker image on Ubuntu 18.0.4 - Metabase internal database: PostgreSQL 12 **Metabase Diagnostic Info** ```json { "browser-info": { "language": "en", "platform": "Linux x86_64", "userAgent": "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:69.0) Gecko/20100101 Firefox/69.0", "vendor": "" }, "system-info": { "java.runtime.name": "OpenJDK Runtime Environment", "java.runtime.version": "11.0.4+11", "java.vendor": "AdoptOpenJDK", "java.vendor.url": "https://adoptopenjdk.net/", "java.version": "11.0.4", "java.vm.name": "OpenJDK 64-Bit Server VM", "java.vm.version": "11.0.4+11", "os.name": "Linux", "os.version": "4.15.0-65-generic", "user.language": "en", "user.timezone": "GMT" }, "metabase-info": { "databases": [ "mysql" ], "hosting-env": "unknown", "application-database": "postgres", "run-mode": "prod", "version": { "date": "2019-10-07", "tag": "v0.33.4", "branch": "release-0.33.x", "hash": "9559406" }, "settings": { "report-timezone": "Europe/Berlin" } } } ``` **Severity** This is impacting users (especially external users, seeing dashboards as embedded pages in larger applications) quite heavily because they cannot access the raw data when needed. **Additional context** This might have already been described in #3399, although in a much more unclear version. (I suggest closing #3399).