This topic contains 3 replies, has 2 voices, and was last updated by spyout98 6 years, 1 month ago.
- Topic
On OroCRM Reports page, I can create some reports with these following options for “function” field (see image below):
But, sometimes (for example), I have to create reports that makes, in SQL, COUNT(*) in many rows that can be duplicated (because of a JOIN or a GROUP BY clause or something like this). So, I want to make “DISTINCT” COUNT, or DISTINCT SUM, AVG, MAX and so on.
How do I do that in OroCRM Report? Because currently there is a options for “DISTINCT COUNT”, “DISTINCT SUM” and so on. I want to make DISTINCT in results before agregate them in a COUNT, AVG or SUM sql operator.
The forum ‘OroCRM’ is closed to new topics and replies.