Metric definitions for Boolean fields

[GM5]

Hello,

I'm currently noticing that Values for Boolean fields on a metric are being set as Date time values instead of "True" or "False" values, if you see the image the idea of that metric is to check Field value changes , is there any way to make this to be a True/False value instead of that Date time string?

This is the field:

[Dr Atul G- LNG]

Hi @GM5 

I think it is expected behaviour, I tried this in my PDI and got same results. the reason can be 

As this calculate the duration, try with other option script calcualtion. but I doubt any thing will be changed.

[GM5]

What about the Other fields on the screenshot? These aren't Boolean type every time a user perform a change on the value of the field a new metric instance is created and we are able to see the new value, see the attached image. Basically this report is feed by a Database view between our custom table and the metrics table (ServiceNow suggest there's an OOTB database view for Change and other tables to fulfill the same requirement without using the audit table) .

Thanks anyways. 

[Dr Atul G- LNG]

Hi @GM5 

LNG_P is a boolean type, which was created on the Incident table test your use case.

[GM5]

Hi thanks for taking the time to research this, but I'm affraid that this is not the planned behaviour I just opened a servicenow Instance and created a metric for an OOTB checkbox field on table incident and also a metric for a custom checkbox field on the same table and the results are what we are expecting, we got the current value of the field, see attached this could be something else going on our instance.

This is done by an on Insert OOTB Business rule called "metrics instance - set display value" wich basically sets the "Value" field with whatever is on the form. 

I've compared both scripts and they are exactly the same, might need to reach SN HI.