ServiceNow Platform analytics

[Alpha_K]

Hi All,

I have a requirement in Platform Analytics. 

Requirement:

Table: Incident Table.

Conditions are:

Priority is P1

Major incident state is accepted.

classification is Apps 

Created at or after Jan2023

when all these conditions are met, we need to update the days since Apps P1 Incident.

How the days I am updating now is manually 

Going to the incident table 

Giving all these queries in the filter 

Then running the query

Created date (sort z to a) and then updating the days

I have been trying with the basic reporting and Platform Analytics where I am getting the overall count of the incident in a single score or if i try with any other type in reporting I am getting the counts.

Here the requirement is we need to calculate the days created date(sort z to a) and then need to update the days

Is there any way that this can be done automatically via PA or any other way that this requirement can be achieved?

Please suggest

[Alpha_K]

Hi  @AndersBGS ,

I have been trying this requirement on Performance Analytics, 

Initially I have created a business rule 

Named: Apps

Table : Incident.

when to Run: After 

Insert : checked

Update: checked

Filter conditions Applied :

I have created a custom tabled name" u_reporting_look_up_table".

Advanced:

(function executeRule(current, previous /*null when async*/ ) {

    var gr = new GlideRecord('incident');

    gr.addQuery('priority', 1);

   // gr.addQuery('u_organization_type', App);

    gr.orderByDesc('sys_created_on');

    gr.setLimit(1);

    gr.query();

    if (gr.next()) {

        // Update the custom reference field in the custom table with the latest P1 Incident

        var latestP1Incident = gr.sys_id;

        var customTableGr = new GlideRecord('u_reporting_look_up_table');

        customTableGr.get('667e71001b78a290d8f6968f034bcb53'); // Replace with the sys_id of the record you want to update

        customTableGr.u_number = latestP1Incident;

        customTableGr.update();

    }

})(current, previous);

where in that table I am getting the days since p1 incidents .

I have executed the scheduled job and was trying to get output but it did not display any result.

Please suggest.