How to get running total of number of Knowledge Articles?

NameHere · ‎10-13-2016

In our old system we were able to use Tableau to help us do some analytics. One report that I'm trying to recreate now that we have our new system (ServiceNow) is a running total of number of Knowledge Articles. For reference, here's what it looked like in Tableau before...

I've tried to use ServiceNow's Report module to create this same type of graph but am unable. The below shows my attempt...

So really the above graph would then just show how many Knowledge Articles we made each month, not a running total.

I even tried an Aggregation by Sum instead of Count - but the problem with Aggregation by Sum is that it only allows for 4 fields (Rating, Updates, Use Count, View Count) to Sum on, not the total number of Knowledge Articles.

Is there a way to do this in ServiceNow? We have the Express version now but will be upgrading this week to Enterprise.

Thanks for all your help community!!!

mrswann · ‎10-13-2016

I think and you will need to check with your Account rep that you can have some free version of PA which is limited to Incident content pack without any adjustments to dashboards, collectors, indicators, etc..

The premium is unlimited and you get content packs galore, plus you can modify and build your own

The difference (to just normal Reporting) would be , it will run a job over a period of time and take some predefined date parameters - so for Knowledge you may want to know created or you may want to know published...

as an example it may want to check [ Published <= Today, and retired is empty or > today ] which means at that point in time it was published, and that will create an aggregation value (count) for that date

It will then continue to generate and record that value - against which you can form a time series visualisation and track that

View solution in original post

mrswann · ‎10-13-2016

Do you have Performance Analytics premium?

Interestingly in Helsinki there is a KB content pack OOTB included in the Upgrade..

NameHere · ‎10-13-2016

We likely do not. I was just using the Reports module inside in ServiceNow Express to generate the above report.

We will be upgrading to ServiceNow Enterprise this week. Does Enterprise have the Performance Analytics premium built in or is it an additional cost add-on?

Thanks!

mrswann · ‎10-13-2016

I think and you will need to check with your Account rep that you can have some free version of PA which is limited to Incident content pack without any adjustments to dashboards, collectors, indicators, etc..

The premium is unlimited and you get content packs galore, plus you can modify and build your own

The difference (to just normal Reporting) would be , it will run a job over a period of time and take some predefined date parameters - so for Knowledge you may want to know created or you may want to know published...

as an example it may want to check [ Published <= Today, and retired is empty or > today ] which means at that point in time it was published, and that will create an aggregation value (count) for that date

It will then continue to generate and record that value - against which you can form a time series visualisation and track that

NameHere · ‎10-13-2016

Unlike our Express instance, I just checked in our stage environment for Enterprise and there IS the Performance Analytics module in it. I'm not sure if it's fully ON and ready to make these reports, but I'll check later next week. Thanks for the head start!!!