It sounds like you only have community (not Response). But, if you had a Response (aka LSW) instance and your Community was connected to it via the Lithium API, it's really easy to get the data you're looking for. I'm posting in case you or anyone else is in that situation. You'll need to create 1 tag first: Create a tag that has a lucene rule to look for "Re: " (literally, with the quotes). We'll call this the 'reply tag'. Then you'll need to create a new smartview with these attributes: "All of These" - enter "Source > Lithium" tag, so you're just looking at conversations pulled in from your lithium instance. "Any of These" - enter your 'reply tag'. So you're now looking at community threads that contain "re: " in them. They're threads with replies. "Exclude These" - enter "Annotation > Accepted solution". This is a system tag. Now you've excluded all conversations with an accepted solution. In analytics you can view the smartview and can view all conversations that meet its criteria, and open each individually. I learned this and a whole lot more by working with Meg Hahn @ Lithium. She is fantastic.
... View more