- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-16-2022 03:08 AM
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
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-16-2022 03:26 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-16-2022 03:26 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-18-2022 01:46 PM
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.