When creating a report that uses aggregation, such as a Bar chart, if you want to aggregate with a Distinct Count it only gives you the option to aggregate on Reference fields. I want to aggregate based on a String field (such as Number in an incident). How can you do this type of Distinct Count aggregation in a report?
I have followed same approach,Field is updated in List view for Sys_Report table, but when u open report template(actual report), then in Aggregate field...it is not showing
