How do I report on count of knowledge articles by category?

[Shelly Easley]

I'm trying to create a report that shows ALL of my Knowledge categories with a count of the number of articles within each category. I'm using this to monitor the usage of the categories and remove or consolidate categories that have few or no articles within them.

I have been able to see all articles with their associated categories, a list of categories and their number of updates (but not number of articles with this category), view counts, use counts, etc. But I just need a simple report that shows:

- Knowledgebase

- Parent ID (would be helpful but not mandatory)

- Category (Preferably "Full Category" but just "Label" would work)

- Count or Number of articles within this category

Anyone have any ideas?

[Kim Tillano]

I set it up in a bar graph and you can click each section to see the breakdown, but you could set it up in list view and choose the columns if you prefer:

[Kalease Tech]

What columns should be used to get the count when switching to list view? I've looked through the table a few times but can't find the proper field. 

Thanks

[Kim Tillano]

If you're still looking to get counts by category, just change the "Group by" field to kb_category, but you could group by knowledge base or whatever you want.  Then it will group them and show the counts on each line.  You can expand each section to see the actual articles in list view:

 

[Shelly Easley]

These are all good options. However, they still don't display categories with zero (0) articles assigned to that category. However, I think I can still find them by exporting the data to excel and using a vlookup against all possible categories. Not ideal, I'd rather be able to display it directly in the tool, but I can at least get there. 

[Kim Tillano]

There must be a way.  Let me poke around and see what I can come up with.