IN operation in a calculation . Pass a list of values from a column

Q&A
,
1

I am trying to do a simple IN operation that we do in ex - where payment_method in (‘stripe’, ‘applepay’, ‘googlepay’)

How can I do this as a calculated field in quicksight . I want to do a distinct_countif

amount where payment_method in (‘stripe’, ‘applepay’, ‘googlepay’) and use other column consitions such as transaction_status = ‘successful’.

I tried a few things but it didnt work - ex :

distinct_countIf(

{money_transfer_id}, {transaction_status} = ‘successful’

and ({destination_fundholder_type} = ‘User’ OR {destination_fundholder_type} = ‘OneTimeUser’)

and ({payment_method_type} = ‘stripe’ OR {payment_method_type} = ‘applepay’ OR {payment_method_type} = ‘googlepay’)

)

distinct_countIf(

{money_transfer_id}, {transaction_status} = ‘successful’

and {destination_fundholder_type} = ‘User’,‘OneTimeUser’

and {payment_method_type} = ‘stripe’,‘applepay’,‘googlepay’

)

2

I think I get it now. I was able to do so -

distinct_countIf(

{money_transfer_id}, {transaction_status} = ‘successful’

AND ({destination_fundholder_type} = ‘User’ OR {destination_fundholder_type} = ‘OneTimeUser’)

AND ({payment_method_subtype} = ‘stripe’ OR {payment_method_subtype} = ‘applepay’ OR {payment_method_subtype} = ‘googlepay’)

)

3

You can see the correct syntax for the in function here:

distinct_countIf(
	{money_transfer_id},
	{transaction_status} = ‘successful’ AND in({destination_fundholder_type}, ['User', 'OneTimeUser']) AND in({payment_method_subtype}, ['stripe', 'applepay', 'googleplay'])
)