Forum Discussion
Modeling issue
Hi Jensej ,
One thing that I'm not getting in the information you are giving is how are the 3 tables connected with the groups? Taking into account that you say you need the information by the groups you need to have that relationship between your table ate least the employees and the clients, these depends on how you have your data and but believe is a key part to have eveything working properly.
Concerning the secon question about the several dates you have two options to have one active relationship and then inactive relationships and make use of USERELATIONSHIP formula to activate the inactive relationship when you need them, another is to have no relationship and then make use of FILTER function to get all the values working.
Both options have advantages and disavantages so depends on what you want to see.
Hope this helps to get some light on your issue if you need further assistance please tell me.
Hi MFelix !
Thanks for your reply.
Regarding your question about the groups.
In the view for the clients there is a column which says what group they are in with following values (Group A, Group B, Group C, Group D, Group E)
In the view for the Employees there is also a column that tells where they work. (Amsterdam,Boston,Chicago,Domodossola)
A = Amsterdam, B = Boston, C = Chicago and D/E = Domodossola.
Notice that Employees that work for Group D or E are togheter.
About the second reply. I want a slicer with a date on every page on the report where they can choose a date and then it should only return the clients/employees that was in the company at that date. (Filtering on hire and resign date and client entry and exit date).
What's best? One active connection or two unactive?