Aggregate counts

I have 2 columns: email and campaign. Currently, there are 2 campaigns. How can I calculate which users were part of both campaigns? Also, how does this metric compare to the count_distinct of all emails?

Thank you!

Hi @maksym1

Welcome to Quick Sight Community .

Could you please check the sample calculations done in Quick Sight Arena.

31667

Did this solution work for you? I am marking this as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the Quick Sight Community Q&A Forum!

Thanks
Vinod

1 Like