help with logic  finding unique number of `column1` that have BOTH value '1' and '2' from `column2`
I am struggling through working out the logic for this. Can anyone help me think through this? There might be an entirely different approach that is much easier.
I am sorting out an email campaign and I want to know how many unique `EmailAddress` show up for BOTH `EmailName` value 'email1' and 'email2' at least 1 time.
(To clarify, this is an open report I am working with, so a new row populates with `EmailName` for each open. so if a person opened 100 times, that would be 100 rows, same `EmailAddress`.)
I created new columns with integers for each of the emails.
So, `Email1Column` is filled with:
CASE WHEN `EmailName` like '%Email 1%'
then 1 else 0 end
`Email2Column` has:
CASE WHEN `EmailName` like '%Email 2%'
then 1 else 0 end
I created a table that has `EmailAddress`, SUM Email1Column and SUM Email2Column as the columns.
I want to filter ONLY the rows that have a value greater than 0 for BOTH Email1Column AND Email2Column.
When I try to put in filters on the visualization, it is just empty (for the same reason I can't use an AND statement  the data is different rows, so >0 for one means excluding the other).
I feel like I am close here. Any help is appreciated.
Comments

Hi @cjackPML
You can't filter on aggregate functions (unless you have an alpha feature enabled to do so but doesn't always work as intended).
What I'd recommend is using an ETL (or a DataView if you're in the beta) to calculate these numbers and then using the resulting dataset to graph where you can filter on the aggregated numbers.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 
Thanks @GrantSmith for the response.
I did use an ETL to generate those two new columns.
Can you elaborate on what I should do? I am just hitting a wall on thinking this through. Do you mean I should create a column that only includes the greater than 0 rows for each? I suppose that would make sense.
0 
Hi @cjackPML
You'd need to do your grouping and aggregation within your ETL using a GROUP BY tile and creating two new fields (email 1 min and email 2 min). Then add both together using a calculator tile. If the new value is 2 then they both would exist and you can then use that new field to filter on in your cards.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
 7.7K All Categories
 3 Connect
 919 Connectors
 244 Workbench
 477 Transform
 1.8K Magic ETL
 60 SQL DataFlows
 446 Datasets
 37 Visualize
 198 Beast Mode
 2K Charting
 8 Variables
 1 Automate
 348 APIs & Domo Developer
 82 Apps
 Workflows
 14 Predict
 3 Jupyter Workspaces
 11 R & Python Tiles
 241 Distribute
 59 Domo Everywhere
 241 Scheduled Reports
 15 Manage
 36 Governance & Security
 27 Product Ideas
 1.1K Ideas Exchange
 Community Forums
 14 Getting Started
 1 Community Member Introductions
 49 Community News
 18 Event Recordings
 579 日本支部