lightdash / lightdash

Self-serve BI to 10x your data team ⚡️
https://lightdash.com
MIT License
3.63k stars 381 forks source link

When I export the data from a table visualization that's pivoted, I want the pivot to be kept in the export. #6838

Open TuringLovesDeathMetal opened 11 months ago

TuringLovesDeathMetal commented 11 months ago

Description

Right now, if I try to export the results from a table visualization that's pivoted, the results are exported un-pivoted.

e.g. this table:

image

exports to a .csv that looks like this:

image

I want to be able to export my .csv so that the pivot is maintained.

Acceptance criteria

E.g. in this image, the month would be repeated across columns in the exported file:

image
lightdash-bot commented 3 months ago

This issue was mentioned by a user in slack: https://lightdash.slack.com/archives/C049LQZGVD3/p1713260393473329?thread_ts=1713260393.473329&cid=C049LQZGVD3

etadelta222 commented 1 week ago

+1