Khoros Atlas Logo

%3CDIV%20class%3D%22lia-message-template-content-zone%22%3E%3CLINGO-SUB%20id%3D%22lingo-sub-221004%22%20slang%3D%22en-US%22%3EReplies%20but%20not%20accepted%20solutions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-221004%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20be%20able%20to%20run%20a%20report%20that%20shows%26nbsp%3Bhow%20many%20posts%20had%20replies%20but%20not%20Accepted%20Solutions%20within%20a%20certain%20date%20range.%20Do%20you%20know%20how%20I%20can%20search%20for%20them%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-240867%22%20slang%3D%22en-US%22%3ERe%3A%20Replies%20but%20not%20accepted%20solutions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-240867%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20sounds%20like%20you%20only%20have%20community%20(not%20Response).%20But%2C%20if%20you%20had%20a%20Response%20(aka%20LSW)%20instance%20and%20your%20Community%20was%20connected%20to%20it%20via%20the%20Lithium%20API%2C%20it's%20really%20easy%20to%20get%20the%20data%20you're%20looking%20for.%20I'm%20posting%20in%20case%20you%20or%20anyone%20else%20is%20in%20that%20situation.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou'll%20need%20to%20create%201%20tag%20first%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECreate%20a%20tag%20that%20has%20a%20lucene%20rule%20to%20look%20for%26nbsp%3B%22Re%3A%20%22%20(literally%2C%20with%20the%20quotes).%20We'll%20call%20this%20the%20'reply%20tag'.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20you'll%20need%20to%20create%20a%20new%20smartview%20with%20these%20attributes%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22All%20of%20These%22%20-%20enter%26nbsp%3B%22Source%20%26gt%3B%20Lithium%22%20tag%2C%20so%20you're%20just%20looking%20at%20conversations%20pulled%20in%20from%20your%20lithium%20instance.%3C%2FP%3E%3CP%3E%22Any%20of%20These%22%20-%20enter%20your%20'reply%20tag'.%20So%20you're%20now%20looking%20at%20community%20threads%20that%20contain%20%22re%3A%20%22%20in%20them.%20They're%20threads%20with%20replies.%3C%2FP%3E%3CP%3E%22Exclude%20These%22%20-%20enter%20%22Annotation%20%26gt%3B%20Accepted%20solution%22.%20This%20is%20a%20system%20tag.%20Now%20you've%20excluded%20all%20conversations%20with%20an%20accepted%20solution.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20analytics%20you%20can%20view%20the%20smartview%20and%20can%20view%20all%20conversations%20that%20meet%20its%20criteria%2C%20and%20open%20each%20individually.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20learned%20this%20and%20a%20whole%20lot%20more%20by%20working%20with%20Meg%20Hahn%20%40%26nbsp%3BLithium.%20She%20is%20fantastic.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-221248%22%20slang%3D%22en-US%22%3ERe%3A%20Replies%20but%20not%20accepted%20solutions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-221248%22%20slang%3D%22en-US%22%3E%3CP%3ESo%2C%20any%20idea%20how%20to%20export%20the%20text%20of%20those%20replies%20where%20there%20wasn't%20an%20accepted%20solution%3F%20We%20want%20to%20review%20the%20replies.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECordelia%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-221092%22%20slang%3D%22en-US%22%3ERe%3A%20Replies%20but%20not%20accepted%20solutions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-221092%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%2C%20very%20helpful!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-221011%22%20slang%3D%22en-US%22%3ERe%3A%20Replies%20but%20not%20accepted%20solutions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-221011%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fcommunity.lithium.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F51997%22%20rel%3D%22noopener%20noreferrer%22%3E%40Cordelia%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20would%26nbsp%3Bgo%20to%20Advanced%20Metrics%2C%20set%20my%20time%20frame%2C%20choose%20the%20Forum%20Topics%20metric%2C%20then%20do%20another%20for%20Accepted%20Solutions.%20The%20number%20of%20threads%20that%20had%20replies%20that%20have%20not%20been%20marked%20as%20an%20Accepted%20Solution%20will%20be%20the%20first%20result%20minus%20the%20second%20result.%20A%20relatively%20simple%20calculation.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHope%20that's%20helpful.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EJason%3C%2FP%3E%3C%2FLINGO-BODY%3E%0A%3C%2FDIV%3E
Highlighted
Occasional Contributor
Occasional Contributor

Replies but not accepted solutions

Jump to solution

I want to be able to run a report that shows how many posts had replies but not Accepted Solutions within a certain date range. Do you know how I can search for them?

4 Replies 4
Highlighted
Honored Contributor Honored Contributor
Honored Contributor

Re: Replies but not accepted solutions

Jump to solution

@Cordelia

 

I would go to Advanced Metrics, set my time frame, choose the Forum Topics metric, then do another for Accepted Solutions. The number of threads that had replies that have not been marked as an Accepted Solution will be the first result minus the second result. A relatively simple calculation. 

 

Hope that's helpful.

 

Jason

Generic1.jpg

Reply
Loading...
Highlighted
Occasional Contributor
Occasional Contributor

Re: Replies but not accepted solutions

Jump to solution

Thank you, very helpful!

Reply
Loading...
Highlighted
Occasional Contributor
Occasional Contributor

Re: Replies but not accepted solutions

Jump to solution

So, any idea how to export the text of those replies where there wasn't an accepted solution? We want to review the replies.

 

Cordelia

Reply
Loading...
Highlighted
Respected Contributor
Respected Contributor

Re: Replies but not accepted solutions

Jump to solution

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.

Reply
Loading...