Forum Discussion
How can my table connection be?
Hi guys, im having some troubles with the connections of my tables.
Initially I had 2 tables:
Interactions and clients, they obviously are connect by the ID number. They have the following component.
Interaction_Table: CREATION DATE ; INTERACION TYPE (It should be client creation in order to be considered);CLIENT ID (It can be a blank value); ORIGIN
Cient_Table : CREATION DATE; CLIENT ID; ORIGIN; LEVEL OF INTEREST
I want to have 02 graphics.
First one will show how many new clients do I have according to its origin.
Second one will show how many clients do I have according to its level of interest.
I need to have 02 filters: Year and Origin, so my graphics could be interactive.
So far I´ve created and calendar table, but origin filter doesnt work for the second graphic.
What can I do?
Thanks!!!
Have an inactive date join between date and client. And Active between client and interactions. Date and Interaction - Active.
For a measure you need the Client and date join and use userelation. If need add a cross join for Either Date and Interaction or client -Interaction
2 Replies
Have an inactive date join between date and client. And Active between client and interactions. Date and Interaction - Active.
For a measure you need the Client and date join and use userelation. If need add a cross join for Either Date and Interaction or client -Interaction
