How can I see the number of articles within a category?

[Keszia]

Hi everyone, I'm wanting to create reports that can tell me the number of active articles.

For example:

• The parent category is "Parent Category"
  • "Sub Category 1" has 10 articles
  • "Sub Category 2" has 5 articles
  • "Sub Category 2" has 6 articles
  • "Sub Category 2" has 9 articles

However, when I try to create a report using kb_category and grouping by Label, it just tells me that "Parent Category" has 4 Sub Categories with true=1, so the pie is equally split 4 ways, rather than it being split by 10/9/6/5.

Really hoping there's a way to do this, as I really benefit from having visuals at-a-glance and would like to have the data in one place, rather than needing to navigate to the Knowledge Base itself to see the number of articles in the Sub Categories.

[Pam Calvey]

How have you set up the field values? 

[Keszia]

Sorry Pam, I'm not sure how to answer that? I'm more of a user than admin of the KB.

[Dave Littlejohn]

I believe you need to be reporting on the kb_article table rather than kb_category. Then you can group by Category.

[Keszia]

Hi Dave, when looking at the kb_article table - I don't get category as an option to group by.