Expand my Community achievements bar.

SOLVED

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

Avatar

Level 3

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?

 

variables.png

 

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

 

Kind regards,

Blanca

1 Accepted Solution

Avatar

Correct answer by
Level 3

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.

vt0509_0-1718858558027.png

 

View solution in original post

1 Reply

Avatar

Correct answer by
Level 3

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.

vt0509_0-1718858558027.png