Having group in reports

[thedudi]

Hi,
I'm trying to leverage the Having group capability within report without a success.
e.g. Trying to generate report to group opportunities by customized groups of probabilities.
Any insights would be appreciated.

Thanks.

[Maximus]

Hi,
Have you read this https://docs.espocrm.com/user-guide/reports/#columns (see non-aggregated columns)?

[thedudi]

Hi, yes, but it's not answering my use case.
My use case would be - aggregate into two groups, based on the probability field. e.g. Below 50% / Above 50%.

[eduardofendrich]

Hi, I've read about non-aggregated columns, but I'm not able to add them. Is there any documentation about how to insert them?

[Vadym]

Hi
Eduardo,

Hope, this thread will be helpful:

https://docs.espocrm.com/user-guide/reports/#columns

[eduardofendrich]

I saw the link, however there is no information about how to add a non-aggregated column to the report. I have available only "group by", "columns", "order by" and "filters" available. Nothing about non-aggregated columns.

[Vadym]

Eduardo,

Non-aggregated columns (Assigned user, City, Country, Created At, Email etc.) - this is columns without aggregate functions (COUNT, SUM, MIN, MAX, AVG)

[eduardofendrich]

Hi,

I'm not able to add non-aggregate columns. The fields are not shown and I'm not able to insert them by drag and drop or typing directly field name.

[yuri]

It works only if Group By has 1 or 0 items. It does not work for 2 (and will never be I think).

[eduardofendrich]

It works only if Group By has 1 or 0 items. It does not work for 2 (and will never be I think).

Thanks. With 1 "group by" item it's possible to add.

Each time I realize that it's impossible to group by more than 2 items, I'm more convinced to abandon the project and restart from the scratch with another software.