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

Christoph4
Tera Contributor

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.

find_real_file.png

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

 

 Christoph

1 ACCEPTED SOLUTION

Jaspal Singh
Mega Patron
Mega Patron

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.

View solution in original post

2 REPLIES 2

Jaspal Singh
Mega Patron
Mega Patron

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.

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.