Custom Content Block – Incidents Resolved This Month

Had to create a custom content block table to show Incidents resolved this month.

Format had to be Assignment Group, Number of Incidents Resolved, Average Duration, and Average Duration in Hours.

<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">
 
 <style>
 <style>
	
table{

  
}
	 


th{

	 border: 1px solid #000000;
	 color: #50c878;
	 font-family: "Times New Roman";
	
 text-align: left;
 padding: 2px;
	 font-size:28px
	 }
	 
	 td {
	border: 1px solid #000000;
	color: #000000;
	 font-size:23px;
 text-align: left;
 padding: 2px;
	 
 
}

tr:nth-child(even) {
 background-color: #E8E8E8;
}
</style>
 </style>
<g:evaluate>
   	 var agg = new GlideAggregate('incident');
agg.addEncodedQuery("stateIN6,7,8^resolved_atONThis month@javascript:gs.beginningOfThisMonth()@javascript:gs.endOfThisMonth()")
agg.addAggregate('AVG', 'calendar_duration');

agg.addAggregate('COUNT');
agg.groupBy('assignment_group');
agg.orderByAggregate('AVG','calendar_duration');
	
	
agg.query();
	  
	
  </g:evaluate>
	

<table width="100%">
 <tr>
 <th>
		 <b><center>Assignment Group</center> </b>

 </th>
 <th>
 <b > <center> Resolved </center> </b>
 </th>
 <th>
  <b> <center> Time to Resolve </center> </b>
 </th>
 <th>
 <b> <center> Duration in Hours </center> </b>
 </th>
	
 
 </tr>
  <j:while test="${agg.next()}">

	   <g:evaluate>	

			    var agr = "${agg.getAggregate('AVG', 'calendar_duration')}";
	  
	  		   var dur = new GlideDuration(); 
dur.setDisplayValue(agr);

var days = parseInt(dur.getDayPart(), 10);
var hours = parseInt(dur.getByFormat('HH'), 10);
var minutes = parseInt(dur.getByFormat('mm'), 10);
		   
	var days0 = parseInt(dur.getDayPart(), 10).toFixed(0);
var hours0 = parseInt(dur.getByFormat('HH'), 10).toFixed(0);
var minutes0 = parseInt(dur.getByFormat('mm'), 10).toFixed(0);   

var totalHours = parseFloat( (days * 24) + hours + (minutes / 60) ).toFixed(2);

	
		  
  </g:evaluate>

	  
	 
	 
 <tr>
 <td style="color:#50c878;font-family: 'Times New Roman';">
	 <b> <center> ${agg.assignment_group.getDisplayValue()}</center></b>

 </td>
 
 
 <td>
	 <b> <center> ${agg.getAggregate('COUNT')} </center></b>

 </td> 
 
 <td>
	 <b><center> ${days0} Days ${hours0} Hours ${minutes0} Minutes</center></b>

 </td>
 
 <td>
	 <b><center> ${totalHours}  Hours </center></b>

 </td>

 </tr>
</j:while>
  
 </table>


</j:jelly>