How to exclude weekends and if possible holidays from Automated indicator and formula indicator?

[Kartikeyan Mag2]

We have created Automated Indicators "Incidents opened on today", "Incidents opened on this week", "Incidents opened on this month" and "Incidents opened on this quarter"

And using above indicators we have created formula indicators "[[Incidents opened on today / By week AVG +]]", "[[Incidents opened on this week / By month AVG +]]", "[[Incident opened on this month / By quarter AVG +]]" and "[[Incident opened on this quarter / By year AVG +]]"

Now we want to exclude weekends and if possible holidays

so please help us with same

[Akshata jamdar]

Hi Kartikeyan,

You can refer below blog it will help you get out of this issue,

https://community.servicenow.com/community?id=community_blog&sys_id=8eac2625dbd0dbc01dcaf3231f9619aa

Mark the the answer correct and helpful if it will help you in any manner.

Regards,

Akshata

[Kartikeyan Mag2]

This is related to report. We want to exclude it from automated indicator and formula indicator

[Akshata jamdar]

Then you need to write script in Automated indicator, First check the table cmn_schedule, where holidays are updated in the 8-5 weekdays excluding holidays, and write below script

Just cross check the field names.

If it will resolve your query mark the answer correct and helpful.

Regards,

Akshata

[Kartikeyan Mag2]

Thank you so much for reply. But I have some queries -

1. My Automated Indicators are "Incidents opened on today", "Incidents opened on this week", "Incidents opened on this month" and "Incidents opened on this quarter" in that indicator source having conditions "Incidents opened on today", "Incidents opened on this week", "Incidents opened on this month" and "Incidents opened on this quarter" so we are going to exclude weekends then why we considering "duration" and "resolved"

2.What aggregate should i take in automated indicator