Hello. I have 3 cards in my dashboard. Can anyone help me create an ETL for the 3rd column only, please?
Here are the details and filters for each card:
Card 1:
Company Name
not in 'MR'
Destination
contains 'MR', 'TC', 'L', 'NP', 'PP'
show count of ID
——————
Card 2:
Company Name
in `MR'
show count of ID
——————
Card 3 (here's where I'm having a hard time, please help)
Combined output of Cards 1 and 2
Remove duplicate ID
Apply Filter: Company Name
does not contain 'MR'
show count of ID