metabase icon indicating copy to clipboard operation
metabase copied to clipboard

Published 20 hours ago • verified publisher icon metabase

The XLSX download for a pivot table should be pivoted

Open agilliland opened this issue 9 years ago • 8 comments
trafficstars

  • I am using the Chrome browser.
  • My computer's OS is Mac OSX.
  • My Metabase version is v0.17.0

Currently if you run a query which displays a pivoted table of data in the browser then go to download the file you get a different set of results. This is confusing and inconsistent for users. If a table is going to be pivoted it should be that way in the CSV as well.

:arrow_down: Please click the :+1: reaction instead of leaving a +1 or update? comment

agilliland avatar Apr 29 '16 16:04 agilliland

Even better, there should be an option when exporting a pivot table to CSV allowing to choose raw or pivoted data before exporting.

rafaelveloso avatar May 03 '16 11:05 rafaelveloso

Now that we support arbitrary column selections and reordering it should probably also match that.

tlrobinson avatar Jul 29 '16 04:07 tlrobinson

Also an issue when exporting XLSX. This, combined with #7902, makes it difficult to use Metabase for creating the reports we need.

josteinaj avatar May 10 '19 08:05 josteinaj

Is this feature in the works? I did hear that it would be implemented but couldn't find any progress updates?

PISA93 avatar Aug 11 '23 11:08 PISA93

Do we have any news about this feature?

Jordan16-95 avatar Apr 10 '24 11:04 Jordan16-95

Can you please update on the priority/road map of this issue?

lea-sheets avatar May 13 '24 17:05 lea-sheets

CSV is merged for 50 here: https://github.com/metabase/metabase/pull/41668/

Reframing this issue around XLSX

cdeweyx avatar May 17 '24 13:05 cdeweyx

CSV is merged for 50 here: #41668

Reframing this issue around XLSX

Awesome!! I just checked ability to do this in our instance and it doesn't seem available yet. Do you know when this will be rolled out?

lea-sheets avatar May 17 '24 16:05 lea-sheets

Reopened as we want to adjust how this feature is introduced into existing downloads.

adam-james-v avatar Jun 25 '24 19:06 adam-james-v

Hi @adam-james-v can I remove the milestone from the issue? Cause it might confuse people into thinking this is fixed for 50.7

Tony-metabase avatar Aug 25 '24 15:08 Tony-metabase

Any news on this happening? I have customers who want a report from me for usage last month. The report needs to be in a cross tab format / pivot table. If met base doesn't want to export it in the pivotable format, because they want to keep customers "in" met abase, that seems a bit defeatist to me. That's not very customer focused.

davidjmorris avatar Feb 07 '25 10:02 davidjmorris

Any news on this happening? I have customers who want a report from me for usage last month. The report needs to be in a cross tab format / pivot table. If met base doesn't want to export it in the pivotable format, because they want to keep customers "in" met abase, that seems a bit defeatist to me. That's not very customer focused.

What version are you on? As of v51 you should see a "Keep pivoted" option on downloads. We are iterating on the performance of this feature for very large datasets, but in most cases it should work well.

Image

cdeweyx avatar Feb 07 '25 11:02 cdeweyx

Ahh! I was creating my own pivot using the query builder. This produced a table with columns along the top, rows on the left and data in the middle. Because Metabase classes this as a table and not a pivot table, the download didn't allow me to keep it formatted with the pivot columns.

I have now remade the query as a standard table, then use the pivot table format to reformat the data in metabase, I now see the tick box in your screenshot to keep data pivoted.

Thanks!

Anyone else who has this problem - remake your query as a "normal" table without columns along the top, and then use the pivotable format in met abase, then you can download the table correctly

davidjmorris avatar Feb 07 '25 13:02 davidjmorris