Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Exports of Pivot Table contains pivot-grouping when question is unsaved #15034

Open
flamber opened this issue Mar 2, 2021 · 0 comments
Open
Labels
Priority:P3 Cosmetic bugs, minor bugs with a clear workaround Querying/Processor Reporting/Export .Team/DashViz Dashboard and Viz team .Team/QueryProcessor :hammer_and_wrench: Type:Bug Product defects Visualization/Tables Raw, summarized, and pivoted tables

Comments

@flamber
Copy link
Contributor

flamber commented Mar 2, 2021

Describe the bug
When using the visualization Pivot Table and the question is not saved (in "dirty" state), then exports include the column pivot-grouping.

To Reproduce

  1. Custom question > Sample Dataset > Products - summarize Count by Category and CreatedAt:Year:
    image
  2. Change visualization to Pivot Table
    image
  3. Export as CSV (XLSX or JSON) - the download includes the column pivot-grouping
Category,Created At,pivot-grouping,Count
Doohickey,2016-01-01,0,13
...
  1. Saving the question and exporting again, now it only includes the columns as expected:
Category,Created At,Count
Doohickey,2016-01-01,13
...

Expected behavior
Never expose system data like pivot-grouping to users.

Information about your Metabase Installation:
Tested 44ce694 (almost 0.38.1)

Additional context
This will likely get fixed when #15008 is addressed.
Found during testing of #15019

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Priority:P3 Cosmetic bugs, minor bugs with a clear workaround Querying/Processor Reporting/Export .Team/DashViz Dashboard and Viz team .Team/QueryProcessor :hammer_and_wrench: Type:Bug Product defects Visualization/Tables Raw, summarized, and pivoted tables
Projects
None yet
Development

No branches or pull requests

3 participants