Add a field on the Count Distinct aggregation options for reports

We are trying to create a report from the incident_metric table and we want to count the distinct values from the "Value" field. However, we can't see the field "Value" on the choices. How can we add this field on the count distinct choices?

To Learn About ServiceNow License and Process End to End

Hi Snow Expertise Team,was Looking out to know the complete process of Snow Licensing in a organization. Because i'am planning to get Snow Software in our Company .please would anyone connect with me. please consider this has high prioirty. 

Mapping of field in Asset & CI

Hi All, I want to map one field named as 'end of life'.How can i map this field in Asset & CI .This field is available in alm_hardware table and cmdb_ci_hardware table. Please suggest. Thanks .

How to extract specific text from string

Hello All, I am trying to extract 'Severity 3' text from below string however unable to pull it: START_REQUESTSUMMARY:Test incidentDESCRIPTION:Ticket created for Test User Test ticket /DESCRIPTIONREF:TICKET#234566CATEGORY:ISSUE_TYPE:SERVICE:ASSIGNME...

Removing Configuration Item (CI) edit access for ITIL role

OOB, ITIL role is permitted to create, read, edit, and delete Configuration Items (CI). We would like to restrict the role to read only for CI's. We understand this involves modifying OOB ACLs.Looking for any feedback from those who have done this. D...

Set Email header

Hi,when catalog item is submitted, we have an email attached to the flow to send for logged in users. but when request is submitted by default the email header is showing instance link instead who submitted the request.Prod.xxxx.comHow to fix this? o...

OnCell Edit make a field readonly

Hi Can someone help me with how to make a field readonly onCellEdit (No ACL) function onCellEdit(sysIDs, table, oldValues, newValue, callback) { var saveAndClose = true; //Type appropriate comment here, and begin script below saveAndClose = false; ca...

Concatenate two fields into one

Im trying to copy the value of two different fields into one when a value is selected from a reference field. when a value is selected form a reference field, I would like to push that value along with the value in another field to a field where both...

How to auto populate current logged in user department in service catalog variables

Basic Reporting application: how to report Average Age of OPEN records from TASK table?

is there a way to create a Single Score type report in the Reports Application that shows "Average Age of Open Records"?    I know about PA, however, that is not an option.  I just need to show this executive that we can show this number..... Average...

Need to add comments on a knowledge article when update

I have been asked if there is a way an author of a Knowledge Article can add comments when and article has been changed when they request it to be published so the approver can know what has changed

How to add hyperlink to risk assessment questionnaire

Hi All I have a requirement where i need to add an hyperlink to risk assessment questionnaire, not to individual question but need to add 1 hyperlink on the top which will be useful for all questions, where it references to a document and user can re...

How to check whether user having approver role but not approved or rejected from last 3 months?

How to check whether the user has an approver role but has not been approved or rejected in the last 3 months? This one's got tricky, just looking for suggestions for better solutions.