Skip to Content
0
Jun 12, 2018 at 06:33 PM

Using Filters in Lumira Discovery 2.1

319 Views

I have been using Lumira Discovery 2.1 to build data quality visualizations. I am trying to create a chart showing the number of e-mails missing either a '.' OR an '@' symbol. The important word here is OR.

I created a filter using 'Does Not Contain'. When I enter only one parameter I get proper results. That is, Does Not Contain '.' returns all records missing the '.' in the e-mail address. Similarly, Does Not Contain '@' returns all records missing the '@' in the e-mail address. However, Does not contain '.' '@' only returns records missing both the period and the at symbol. The filter is clearly using AND to join the two parameters.

My question is, can I create the filter using OR to join the parameters so that it returns all records missing either a period OR an at symbol?

Thanks.