Issue:

The Analysis Mode allows users to add fields from related tables to compare and analyze data more effectively. However, when exporting an Analysis View to Excel, only the records that have been manually expanded are included in the exported file. Any groups or rows that remain collapsed are excluded from the export.

Recommendation:

It would be beneficial to introduce more advanced filtering capabilities for this scenario, including support for filtering by date and time as well as additional criteria. This would help users narrow down the dataset before exporting and reduce situations where Excel needs to retrieve and process an excessively large volume of data.