Report count aggregation > count disctinct are not available

linabenamar
Kilo Contributor

3 hours ago

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
  • 62 Views
2 REPLIES 2

Dr Atul G- LNG
Tera Patron
Tera Patron

2 hours ago

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

nityabans27
Giga Guru

15m ago

HI @linabenamar ,

 

  • 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