Hi, I'm looking to add sum of time worked across change request, incident and sc_tasks, count the number of heads in an assignment group to establish a utilisation % when comparing sum of time worked vs maximum hours.
Count number users in assignment group where 'Is Manager' is false e.g. 3 users
Using static value of 160hrs per month per head e.g. 160hrs per month x3
Total max hours = 480
Sum of time worked across CHG, INC, SC_task = 250
Utilisation = 50%
What's the best way to go about this? Trying to get this all done in servicenow without having to export and mess around with spreadsheets etc.
