Forum Discussion
Solved
Need some help with data model - bidirectional
Hi guys,
I have the following tables:
- Employees: A list of employees
- Certification: A list of dates on which employees have achieved their certification (but only holds an employee ID if they have passed the certification)
- Refresher courses: A list of dates on which these employees have had yearly refresher courses (but only holds an employee ID if they participated to a refresher course)
What I want to a achieve is:
- Have a table visual which shows the employees that haven’t passed their certification exam yet > No issues here
- Have a table visual which shows only the employees that have their certification, and have done their refresher course > Only works when I have bi-directional relationship between the tables.
- Have a table visual which shows only the employees that have their certification, but haven’t done their refresher course yet > Only works when I have bi-directional relationship between the tables (but then only shows the employees that have participated to a refresher course).
Any thoughts on the best setup for this? Should I just merge the tables in the Query editor?
Thanks!
Joren add this measure to the visual filters of the table and set it to 1:
Measure_test = INT(NOT ISEMPTY('Refresher Courses'))
6 Replies
Joren if all tables have one row per Employee (as in the employee column is a unique identifier) then regardless your issues, best practice to merge them to one table (and this is of course will make your solve your requirement easily).
Is this the situation?
Let me know if you need help.Joren add this measure to the visual filters of the table and set it to 1:
Measure_test = INT(NOT ISEMPTY('Refresher Courses'))
