Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a products table and a Company table.
I need to count the companies that have any of the selected products. ("Product 1" or "Product 2" or "Product 3")
I thought about using a table chart but the default logic there is all (must have "Product 1" and "Product 2" and "Product 3")
Try something like this,
Count(DISTINCT If(WildMatch(Products,'Product 1','Product 2','Product 3'),Companies))