How can the values ​​of a query be grouped by a variable | Community
Skip to main content
B
bcollado
Level 3
June 19, 2024
Solved

How can the values ​​of a query be grouped by a variable

  • June 19, 2024
  • 1 reply
  • 1056 views

Hi all team,

 

I would like to ask if its possible to group the values ​​of a query by a variable. We have seen how to do it with the variable that is Key of the table but not with other variables.

 

For example, in this case it groups the emails sent for each request (the key is request) and checking the boxes that I indicate. But how can I group by another variable, for example DNI?

 

 

Maybe it is not possible, but need to be ensure! Thank you very much for your help.

 

Kind regards,

Blanca

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by vt0509

Hi @bcollado , you can group by on any field, and you can do it in the initial Query itself. Just check the "Group" option in the output column. If needed add another field where you can add an expression to perform any function (Sum,Count, etc) on any other field/id.
You need to check below in Additional parameters.

 

1 reply

V
vt0509Accepted solution
Level 3
June 20, 2024

Hi @bcollado , you can group by on any field, and you can do it in the initial Query itself. Just check the "Group" option in the output column. If needed add another field where you can add an expression to perform any function (Sum,Count, etc) on any other field/id.
You need to check below in Additional parameters.

 

    Terms & ConditionsAccessibility statement

    Loading footer...