Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
ATENCIONXUSUARIO | Estado |
---|---|
User1 | Cerrado |
User2 | Cerrado |
User3 | Cerrado |
User1 | Abierto |
User2 | Cerrado |
In the table you can see the example, we have the two columns, in this case i need to count the elements in 'ATENCIONXUSUARIO' column for User 1 and User 2, when the column 'Estado' is "Cerrado", according to the example the result must be 3.
How can i do that???
Best Regards
Hi,
Try with this:
Count({< ATENCIONXUSUARIO={User1, User2} >} Estado)
If the result is different, try to include the DISTINCT Clause:
Count({< ATENCIONXUSUARIO={User1, User2} >} DISTINCT Estado)
Regards,
Ricardo
Thanks for your answer.
With the expression that you suggest we can only count the items that contains User1 and User2 in the column ATENCIONXUSUARIO, but we cant filter to in the column "Estado" the word Cerrado.
How can i do that?
Hi,
Try this.
Count({< ATENCIONXUSUARIO={User1, User2},Estado = {"Cerrado"} >} Estado)
Regards,
Kaushik Solanki