Field not available for "Count Distinct" in Reporting, why?

[Christoph4]

Good morning,

I'm trying to use the "Count Distinct" feature in a Pivot table in Reporting. 

Unfortunately I cannot see the field I'd like to do the distinct count on. We have a custom view that flattens Vulnerable Items and Configuration Items with their apps and I'd like to deduplicate on the Vulnerable Item Number.

What are the prerequisites for a field to appear in the list for "Count Distinct "? 

 Christoph

[Jaspal Singh · Accepted solution]

Hi, 

Can you confirm the type of field? String field is restricted OOB. Suggest you to give link a check once where comments are made by employee.

[kemmy1]

Do you know if there is a sys_property to allow string fields to be Count Distinct?  There are a lot of scenarios where I need a non-reference field to be an aggregated field.