Grid Reports: Count Distinct

[awltrs]

Hello all,

I am currently working with reports in EspoCRM. For one of my use cases, I need to count distinct values. Is there a count distinct aggregate function available? If not, do you have any suggestions on how to make a distinct count work?

Cheers,
Anna

[lazovic]

Hi awltrs,

Only COUNT, SUM, MIN, MAX and AVG aggregate functions ins available in the Reports feature.

[yuri]

Hi Anna,

It's possible to specify complex expression for columns in Grid reports. Complex expressions are translated to SQL internally. Depending on database (MySQL/MariaDB or PostgreSQL), different output is produced.

There's no built-in COUNT DISTINCT function in Espo. But it's possible to add custom complex expression function. https://docs.espocrm.com/user-guide/...stom-functions