Ah yes. I understand.
At first blush, a tool or report like that would be extremely useful, but it gets complicated quickly for a number of reasons. Here are some of them:
1. Pretend that you had a report which said these 50 threads are unsolved. What do you do with it? Give the list of 50 threads to your superusers for them to solve? What if you gave them the list and immediately they told you that those 50 threads have been solved, but nobody has MARKED them as solved! Perhaps the original person asking the question did not go back and mark the 'Accepted Solution'. Perhaps your superusers are waiting on you, the community manager, to mark them as solved because you are empowered to mark them as such
2. What if the threads that are 'unsolved' are not threads that need to be solved? What if these 'unsolved threads' are threads that talk about what a wonderful experience a person had with your brand? To wit, ANY thread without a solution would end up on this list, but not all threads without a solution require a solution
So you have two real issues with what you are requesting. The first issue is that an 'unsolved thread' could, in fact, be solved (but not marked as such). The second issue is that there could be so much noise in the report (i.e. - there are numerous threads that do not even require a solution, yet they end up on the list anyway), that you spend a bunch of time trying to further qualify what should truly be on the list, and you are busy removing stuff off of the list in order to make it truly accurate.
In theory, you could get your list, but for the two reasons above that I mentioned, I dont think it would be immediate cause for celebration. Here is how you could do it:
1. Go into Lithium Social Intelligence (LSI)
2. Set the data range that you prefer (if you have a large or medium szied community set it for 1 day)
3. Go to the Content area on the left
4. Go to the Forums sub-area (within Content)
5. Go to the 'Conversations' tab (directly underneath the 'Forums Overview' section)
6. You will now have a list of the 'Top 50' threads for that 1 day that you set in Step #2
7. Click the 'Solutions Accepted' column over near the right so that you sort all threads that have no solution
8. Export the report into excel and further slice, dice, and sort as you see fit
***IF NECESSARY***
9. If you community is so big that you more than 50 threads in a day, you can select the board from the 'forums' (sort of an extra step before #5 above) tab and then it will default to the top 50 conversations on that particular board
So it is entirely possible to get you what you are asking for; namely, a list of the threads without solutions. I hope that this information helps.
