How to report on Open vs. Closed records?

[Mehernosh Amrol]

I'd like to run a report on Issues in the GRC Module for Open vs. Closed.  I can do this via the Active flag.  Business wants it to say Open for Active and Closed for Inactive.  Is there a way I can change the Label in the report or another way of doing this?

[Mehernosh Amrol]

Thanks, I did try that.

Any idea how I can get rid of the 0's and remove the True/False at the bottom?  I might be able to use this, but the team wants a Pie chart.

[Community Alums]

Hi, 

You wont be able to change the true/false because its a tick box (true/false field) your reporting on.
.
The only way you can do it is to create a new field which looks at the true/false and translate it. Easy way is to create calculated field with the below script. 

(function calculatedFieldValue(current) {

var truefalse = current.fieldname; //add your true/false field name here
if(truefalse){
return "Yes"; //change answer if true
}
else{
return "No"; //change answer if false
}


})(current);

Only drawback is that it will only show on records updated after you have implemented the change so historic data unless its been updated wont be visible.

I believe there's been an idea proposed with servicenow to change this however will be in future releases.

Please mark as helpful or if its resolved the issue correct!