Hi all,
This one might be a bit out there. We are working on bringing in our community involvement metrics via Vanilla > SFDC > Gainsight. Through our community, each question has a thread title that is formatted as “Jacquelyne asked a Question - Report which counts difference in time between titles containing same name” with an Activity Type as “Asked a Question” and then each sub-sequential comment has a thread title “Report which counts difference in time between titles containing same name” with a Activity Type as “Answered a Question”. Initial questions and comments have a date/time stamp. I am wanting to build a report that recognizes when a question has been posted, and how long it takes for it to get an answer. In order to do this, I think I need to make Report Builder understand that threads with titles that CONTAIN the same title should only be looked at, but I can’t figure out how to make this work. Any ideas?