Is there a way to export different fields from what is shown in the visual? I have a table with the following fields shown: date, title, text. I have chosen that because if I include another field, market for example, I get duplicates since I have records that are identical except for different market tags. However, when the table is exported (csv or Excel) I DO want that market field. The user will have selected (via a control) only one of the markets and thus only one instance of the record for that particular market. In the instance where the user should happen to select both of the markets tagged to that record, I can live with the record showing up twice.
Hello @devens , welcome to the Quicksight community!
Have you tried using the hide feature for tables?
You will also need to make sure that when you publish your dashboard that you go into advanced settings and allow hidden fields to be exported.
Thank you Duncan,
I wasn’t aware of that, so thanks for making me aware of it. However, when I try to use that feature I still see the duplicate records due to the different market tags, even if I can’t see the market tag itself. Essentially I’m trying to export a table with more rows than the table seen in the dashboard, since those records with different market tags would, ideally, be shown as only one record in the dashboard but would show up as separate records in the exported file. Maybe what I want isn’t possible, but I thought I’d ask. Thanks again.
Hi @Devens, maybe you can try pivot table. You can collapse, then expand before exporting to Excel or CSV. Another option is to have a separate sheet called “Export to Excel” with all the relevant content.
Exhibit A - Pivot Table
Exhibit B - Export to Excel sheet
Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!