Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How do I add a table visual using filtered values from multiple tables?

I have a table visual with data from multiple (5) tables. I need to create one table that contains filtered data from each table. The filtering must all be using "or" not "and". 

 

Here is a sample of my data:

 

Parent AccountChild AccountDDD Percentile JunePPP JuneMay Touch PointsMay CasesSubmissions
ABCREG2514.23 30
DEFMFG9528.2  345
XXXAHA6436.22 98
CCCMCA4515.2  0
DDDRWA2216.0  25
GGGRHB10018.23 1189
TTTRHP8825.23  78
JJJJHJ7818.93 65
OOOCHH6323.2  0

 

I need to create a table visual that displays the following: 

Any Parent or Child account where DDD Percentile June is less than 80

or Any Parent or Child account where PPP June is greater than 16.6

or Any Parent or Child account where May Touch Points is blank

or Any Parent or Child account where May Cases is blank

or Any Parent or Child account where Submissions is equal to 0

2 Replies