Export aggregated data using MongoDB Compass

Question

Can we export aggregated data from MongoDB compass 'Aggregation' section after applying the last stage of aggregation? Like we can do it easily using 'export data' option under 'Documents' section and we get options to export it as JSON and CSV. I only see options to export the aggregation code from left side.

Numerator

Answer 1

I think the best way is to use the dedicated feature export data (next to "add data" button)

And write here your own query :

Or save the result of all your stage as a view (it creates a new collection with your results) and export the data (as previous pictures):

Woodchopper

Thank you but I don't think that box 'export query with filters' is editable. And as I am on aggregation section, after I have applied all the aggregation function, there is no option to export data (that is displayed after the last stage of aggregation is applied) – Numerator

I just remember, you can create a view from the result of all you stage applied (with de button save -> create a view). And after export all data in the view with my previous post. – Woodchopper

Yes creating a view helped reflect the aggregated functions to documents. Thank you so much! Appreciate it! – Numerator