We create articles for all of our product defects, and we are trying to run a report that shows the number of ticket organizations associated with a specific defect article, by way of Knowledge Capture events in tickets submitted by that organization. We are designating our defect articles by adding the defect number (which includes "(D-") in the article title.
We have tried this Calculated metric:
IF (CONTAINS(UPPERCASE([Article translation title]),"(D-"))
THEN [Ticket organization]
Which returns the correct articles (those containing (D- in the title) but when we insert this metric with DCOUNT or COUNT the number it returns is the number of Knowledge Capture Events per Organization that are associated with that title, not the number of Organizations per ticket. For example, if an article was linked twice in a single ticket, we will see a 2 next to the article even though it was just a single ticket for a single organization. What we would like to know is the number of organizations.