Report count aggregation > count disctinct are not available

Lina17
Giga Contributor

‎09-15-2025 08:30 AM

The columns are not appearing in Report > Aggregation > Count Distinct, even though the value is correctly set as a string. What should I do please ? 

 

Thank you in advance ! 

Regards, 

0 Helpfuls
  • 458 Views
4 REPLIES 4

Dr Atul G- LNG
Tera Patron
Tera Patron

‎09-15-2025 09:13 AM

Any screenshot?

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls

Lina17
Giga Contributor
In response to Dr Atul G- LNG

‎09-15-2025 11:38 AM

Thank you for your help 

Here are the screenshots below

 

linabenamar_0-1757961279954.pnglinabenamar_1-1757961397176.png

 

0 Helpfuls

Lina17
Giga Contributor
In response to Dr Atul G- LNG

‎09-15-2025 11:41 AM

Thank you 

Here are the screenshots below

Lina17_0-1757961586042.png

Lina17_1-1757961661827.png

 

I'm not able to find 'ref client' in the list

0 Helpfuls

nityabans27
Kilo Patron

‎09-15-2025 11:04 AM

HI @Lina17 ,

 

  • Ensure the field is database-backed (not a calculated/script field) and ideally indexed.

  • If it’s still not showing, try converting it to a reference or choice field, and reload the schema before creating the Count Distinct aggregation.

 

0 Helpfuls