Help with signal table: Vendor by two or more payment methods

[santiagolc]

Hi, I need some help with a widget I am trying to make in signavio.

I am looking to see vendors with two or more payment methods.

That is, as I show in the following case:

I would like to only see those cases that have two payment methods like the first three, while the fourth case, I would like it not to appear.

If you have any idea how to solve it, it would be of great help.

Thank you!

[santiagolc]

Hi Nicolas,

i would share my code for the SIGNAL table:

SELECT 
"PO Vendor Name" as "Proveedor"
,COUNT("Payment Method Code REGUH") as "Count Método de Pago"
, case 
when "Payment Method Code REGUH" = 'T'
then 'T - Transferencia Bancaria'
when "Payment Method Code REGUH" = 'Z'
then 'Z - Vale Vista (Pago)'
when "Payment Method Code REGUH" = 'C'
then 'C - Cheques (Emitidos)'
END as "Metodo de pago"
FROM THIS_PROCESS
ORDER BY 2 DESC