A way of determining redundant list items; list items with no data in any module
I'm looking to ensure my modules are as small as possible. In addition to other optimizations I would like to ensure every list item that is contained in some of my bigger reporting modules is needed. I'm defining 'needed' as there is some module in my model that uses the list it's within and has some non-zero value for that list item.
That would be fine if my model only had a handful of modules, however when there are many it becomes quite complex and laborious.
I'm thinking maybe something could be done using the API to iterate through every module that uses a given list, then get the values out of it and compare that to the list items, but I think for that I need to create views and exports for every module specifically for that.
Is this an issue that anyone has encountered before?