Exporting table from DB into file with all data from table including zero data rows/columns

Hi,

I have this table in a dashboard and when I export this table into an excel file, it only shows the rows that have a number > 0. See pics attached. How can i export it so that it exports the whole table, including everything that has 0?

Thanks!

Amanda

Accepted answers

rob_marshall

@aabalos ,

Once you save the Export the way you want, it will be set within that Export action. But, as a best practice so others don't have to go through this Easter Egg hunt, I would create a view with the appropriate filtering (the funnel) based off a boolean line item. Lastly, the last little dropdown is very important, especially if you want others to be able to run it. If you select Myself (Keep Private), others will not be able to see the data exported, but if you specify Everyone, then others will be able to consume it.

Thanks,

Rob

All comments

rob_marshall

@aabalos ,

Ensure no filters are defined in the view (the funnel at the top) or on the export itself. For the export itself, go to Actions and towards the bottom under Exports, find the export action in question. Click Edit and ensure the "Include Empty Rows" is selected.

Hope this helps,

Rob

aabalos

Hi Rob,

Perfect thanks! This is exactly what i needed. Now is there a way to set this as a default for everyone? Or do they need to remember to click on this every time they take an export?

Thanks!

Amanda

rob_marshall

@aabalos ,

Thanks,

Rob

aabalos

Perfect! This worked thanks 🙂

Quick Links

Can you help?

Unanswered questions

OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385