PA: Year to date comparison

[User205728]

Hi all,

I am working on Geneva with PA and have received the following requirement from the client: They want to compare the total number of incidents created this year to date, compared to the same date of last year year to date.

So this would mean that if the number of incidents created in 2016 is 1000 on from Jan 1st until June 1, compare the number of incidents that has been created from Jan 1st until June 1st 2015.

I figured that the Year to date sum option could prove to be the solution, but unfortunately it is not possible to select that specific time aggregation.

I have tried using the times series: previous period chart comparison, but then it only compares the same month of both years (ie april 2015 with april 2016, not jan-april 2015 with jan-april 2016). Quarter to date sum would be the closest approximation, but is not what the client is looking for.

Any idea how to tackle issue?

[Abhinandan Pati]

Hi Dang,

You can use 'BETWEEN' operator in filter to find out the number of incidents created between two dates.

Operators Available for Filters and Queries - ServiceNow Wiki

Condition Builder - ServiceNow Wiki

Thanks

Abhinandan

[User205728]

Hi Abhinandan,

Thanks for the quick reply, but unfortunately my question was not clearly framed.

I meant to create a widget in Performance Analytics which shows the graph with results from this year compared to last year.

[Erik Hoffmann]

Interesting use case. Not sure that it is possible by using the time series in PA (let me think a bit further, and ask around).

One thing that comes to mind is using multiple data sets in a report. That's also a feature of PA:

Using multiple data sets

Try creating a column report trending by created and a condition where created is between Jan 1 2015 and date of today in 2015.

Then create an additional data set also in incident table of report type column, also trending by created, but where the date range is Jan 1 2016 and date of today.

I got the following result doing this quickly.

The trick is then to get the report "move" with the current date. That is not hard for the current year (condition is from Jan 1 2016 to today). But for the previous year it is harder. Maybe with help of a scripted condition? Perhaps other community members can think of something.

Best regards,

Erik

[User205728]

Hi Erik,

The devil is in the details I suppose One option is maybe to manually fill in the date and extract that value and put in a manual breakdown which is used to calculate a score. But this will require manual maintenance and I think this could definitely be automated with a scripted condition.

Do you know any function that calculates the year to date count value?