Calculated field, excel(COUNTIFS) equivalent formula

jgrueso · August 30, 2024, 10:33am

Hi,

Having some troubles to find the a exact replacement for this excel formula:

=COUNTIFS($B:$B,B2,$H:$H,H2,$I:$I,I2)

How can I translate this to a Quicksight calculated field?

Thank you in advance!

prantika_sinha · August 30, 2024, 10:55am

You can frame an ifelse clause using AND and the conditions

example :

count(ifelse( field1=parameter1 and field2=parameter2 and field3=parameter3, 1, NULL)

Thanks,
Prantika

jgrueso · September 5, 2024, 2:46pm

Thank you Pratinka,

I found a different workaround since your proposed solution did not cover one parameter that I forgot.