Forum Discussion
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'))
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.
SpartaBI Logo
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
Showcase Report – Contoso By SpartaBI
6 Replies
- SpartaBI
Community Champion
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.
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.
SpartaBI Logo
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
Showcase Report – Contoso By SpartaBI - SpartaBI
Joren add this measure to the visual filters of the table and set it to 1:
Measure_test = INT(NOT ISEMPTY('Refresher Courses'))
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.
SpartaBI Logo
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
Showcase Report – Contoso By SpartaBI
