I just got some additional information on this request. What they are actually looking for is the number of threads (per container) in a given month that have one or more replies posted to them during that month. I'm still not clear how I would do this in BO. Anyone have any insight on this?
Here is one approach to get the number of posts (message) per thread per container. The query design below will return the count of "Creates" for the Thread Subject. It will also show the count of "Creates" for messages associated with that thread. The trick is to differentiate based on the actual Thread Subject - messages will have the prefix "Re:...." and the count of "creates" associated with that will reflect the number of posts in the thread.
This example includes Container Name so that you can use a drill filter to select threads from a specific container.
The report looks like this:
The top line for each Thread reflects the creation of the thread and the count will always be '1'.
The second line shows the number of subsequent messages associated with the post.
The drop -down filter allows you to pick the container.
I added this to your BO instance at the top level so you can move it wherever is appropriate.
This report is helpful. I'm trying to figure out if there is a way to roll this data up into a summary report for each container on another tab that shows the number of active threads (threads with at least one reply) vs. the number of threads that have not received a reply? To get this I'm thinking you would have to somehow produce a summary that showed the total number of threads whose activity count sum =1 (no replies) and those whose sum >1 (active). Is there a way to do this?