Report for "new" articles published per month and "updated" articles per month

Chuck_P
Tera Contributor

Hi,

Help needed! We want to know how many new knowledge base (KB) articles are published per month. By "new" we mean v. 1.0 articles that have never existed in the KB.  I thought the "created" date would indicate when an article was first published, but it seems the "created" date is updated with each update and/or republish date. I was thinking I'd report the number of v 1.0 articles per month. How can I find the date v. 1.0 was published for the article and report the total out? Or is there a different a better way of getting the report I seek: New published articles per month.  

ServiceNow Article data.png

5 REPLIES 5

Carly6
Tera Expert

The version number is text and not numeric which has tripped me up a lot on this. Our table is customized, so not sure if you'll have the same options, but I do this using these filters on a trending table with Trend by on Published (date):

  • Base Version = Empty (has not been published previously, no New Version has been created)
  • Published at or after One year ago (to just show the past 365 days, you may want to adjust this)

This will show the published rate by month despite what status the KBAs may be in currently, including retired. If you only wanted those that are still published, you'd want to filter on status as well.

 

For updated, I created a trending report with Trend by on Created (date) per Month with Aggregation on Count with these filter:

  • Created at or after One year ago
  • Base Version is not empty (meaning it was previously published and has had new versions created)
  • Release Status is not Retired

This should capture each time a New Version was created of a KBA that has been published at least once. If a KBA has been updated multiple times (new versions, that is), then it will show up multiple times in this report since I'm not using "latest = true".

 

I hope that helps!