I was SO excited to see the new “Expand All/Collapse All” configuration available in Horizon Analytics reporting, as it used to be available in the legacy reporting. However, I was very disappointed to find that the functionality as it exists today is not usable.
For example, we have a report of Products Purchased on the C360. Given our organization, our customers purchase varying products for schools in their district. A large district could have many, many records on this report. The master report that I connect to the Related List will have 1000+ records, easily.
The current functionality of Expand All/Collapse All limits records returned in the report not only in Report Builder but also in the related list reports.
This means, that when I turn “on” Expand All/Collapse All functionality for a report that has 1000+ records on the report (which, any report I make into a Related List on the C360 will be, as it’s not filtered because the C360 filters it for me) it excludes data, both in the user-facing report and in my master report.
Our top use cases for this functionality involve reports that are brought into Dashboards or Related Lists, which have their own filtering capabilities so I do not use filters on the report. Any report that I do not have pre-filtered to return less than 1000 records will not be able to use this functionality.
I am happy to provide screenshots privately with Gainsight!

