Having group in reports

Collapse
X
 
  • Time
  • Show
Clear All
new posts

  • eduardofendrich
    replied
    Originally posted by yuri
    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.

    Leave a comment:


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

    Leave a comment:


  • eduardofendrich
    replied
    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.

    Leave a comment:


  • Vadym
    commented on 's reply
    Eduardo,

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

  • eduardofendrich
    replied
    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.

    Leave a comment:


  • Vadym
    commented on 's reply
    Hi
    Eduardo,

    Hope, this thread will be helpful:
    Last edited by Vadym; 10-19-2021, 02:34 PM.

  • eduardofendrich
    commented on 's reply
    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?

  • thedudi
    commented on 's reply
    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%.

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

    Leave a comment:


  • thedudi
    started a topic Having group in reports

    Having group in reports

    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.
Working...