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.

[Keszia · Accepted solution]

I've found the solution that at least works with how our KB is setup.

The table to use is kb_knowledge and I applied the following filters:

• Knowledge base = desired KB
• Category (kb_category) > Parent ID = Parent ID string of Parent Category
• Workflow = Published

I also grouped by kb_category. 

[SC15]

Hello @Keszia -

To accomplish this task, create the report as below:

- Open report editor by going to Reports - View/Run

- Under Data tab, select table = kb_knowledge

- Under Type tab, select Bar

- Under Configure tab, select as below:

  - Group by = kb_category

  - Stack by = <try to see if you want anything else here> //optional step or leave it blank

This will generate a bar chart where you will see number of articles under each category. When you click on any bar, it will show you all articles under that category with its name and other details.

Let me know if this was helpful and if you have any further questions. Please mark my response as helpful and as a solution, if no more questions. Thanks