D_COUNT(Articles Published) gives different results depending on Attributes on report. | Community
Skip to main content

D_COUNT(Articles Published) gives different results depending on Attributes on report.

  • August 18, 2022
  • 3 replies
  • 0 views
CJ99

Hi,
I'm trying to understand why the number of articles published changes by over 1k depending on whether or not I show the "agent name" attribute. I have the data filtered to exclude 0. 



Showing a total of 2,224 Published Articles. This is with D_COUNT, so they should all be unique articles. 

When I move agent name to the top: 


This is the exact same report. Why is the result so radically different? 

My theory is that the real problem here is that this metric is calculated incorrectly. 
This is the formula; 


IF [Publishing event type - Unsorted]="Translation published"
THEN [Event article ID]
ENDIF

But at a glance that seems wrong to me. The result is "Published Articles" not "# of Times Articles Published". This would count an article that was republished multiple times, each time it was republished, so long as it triggered a new Event Article ID for the publishing, no? 

      3 replies

      Dane13
      • Dane13
      • September 23, 2022
      Hi CJ,
       
      I'll create a ticket for you to directly look into this behavior. Please wait for my update via email and let's continue from there.
      CJ99
      • CJ99
      • Author
      • October 17, 2022

      In the course of the events of the ticket, I was told to literally post this to the forums, even thought that is quite literally what I had done in the first place. 

      TLDR: I am correct, it doesn't work, but despite that, it's not a bug and I should post about it. 

        Dave12
        • Dave12
        • October 18, 2022
        Hi CJ,
         
        I can see how that would be confusing and/or frustrating. We ask our product team to keep an eye on the product feedback topics in our community forums, so that's where we ask others to upvote and add their use cases. The Q&A topics are more the domain of the community management and Customer Care teams. In this case, the Feedback on reporting and analytics (Explore) topic would be the best place for the product feedback version of this post. 
        Terms & ConditionsCookie settingsAccessibility statement