Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
How can the values of a query be grouped by a variable
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
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.
