How to display Time to Publish Knowledge Base articles?

[Mark Nguyen]

Hi PA Community,

I am new to Performance Analytics and looking for some guidance. I have a requirement to display Time To Publish Knowledge Base articles by A) Same Day - 1 week B) 2-4 Week and C) Greater than 4 weeks as seen below from KB0868269.

I am using Facts table kb_knowledge with Conditions Published on This Month.

What conditions do I need to add so I can display Knowledge Base articles published this month by A) Same Day - 1 week B) 2-4 Week and C) Greater than 4 weeks as seen below?

Thank you

[Muralidharan BS]

Hi,

Have you tried adding time series to your time series widget, this should help. below is an example of the time series widget.  This is a OOB widget, you can use this as reference. 

/nav_to.do?uri=%2Fpa_widgets.do%3Fsys_id%3D2a78eba1d7231100b96d45a3ce610309

Docs on time series aggregate 

- https://docs.servicenow.com/bundle/rome-now-intelligence/page/use/performance-analytics/task/create-line-visualization-ts.html#create-line-visualization-ts

- https://docs.servicenow.com/bundle/rome-now-intelligence/page/use/performance-analytics/concept/applying-time-series-aggregations.html#applying-time-series-aggregations

[Mark Nguyen · Accepted solution]

Hi Murali,

Thank you for your response. I was able to meet my business requirement by creating 3 separate indicators and using the following conditions:

A) Same Day - 1 Week

Published is same day as Created .or. Published is same day as Updated .or. Published is less than 1 Weeks after Created .or. Published is less than 1 Weeks after Updated .and. Published on This month

A) 2 - 4 Weeks

Published is more than 2 Weeks after Created .or. Published is more than 2 Weeks after Updated .or. Published is less than 4 Weeks after Created .or. Published is less than 4 Weeks after Updated .and. Published on This month

C) 2 - 4 Weeks

Published is more than 4 Weeks after Created .or. Published is more than 4 Weeks after Updated .and. Published on This month