Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Filter Table A then filter Table B then filter Table A

Hi everyone,

and thanks for all the support.

I post my schema: a table LeadsId and Events are connected with the relation one to many on the filed leadid. There is also the user dimension.

On my page i have in the first table Events (1) for username a measure that count the nr. leads (DISTINCTCOUNT) touched, and this it's ok.
I need to have a table (3) with a measure that counts all the events for all the users of particular lead id selected in the table (1).
Now i use a workaround passing by a table leads (2) that rapresent the leads id selected in the first table (1) i have to select one to one the leads that i need and then expose the measure in the Table (3).
The table (1) doesn't filter the table (3).
There is a way to write a measure that filter the table events by the lead id selected in the first table (events)?
Something like this sql query:
Select EVENTS ID
from EVENTS (3)
where LEADID in (LEAD ID selected in the EVENTS TABLE (1)).
I hope i was clear.
Thank you very much.

 

2 Replies