Forum Discussion
Use one date table
Hi Anonymous ,
I'm sorry I'm not clear about your requirement... Could you please provide some sample data in these three tables and your desired result? Whether the relations among them be set same with the one in below screen shot?
Relationship
Desired result??
Best Regards
Rena
Hi Anonymous
What i see in your example is that you cant slicer both tables. Employee entry date and training date.
That is my problem.
I want in the same page, to use a slicer from "Date table" which allows me to filter both tables.
As you show, one relation is inactive.
If i use the function "Use relationship" it will work only for that countThanks
I'm confused as to what you're actually trying to do here - I can get you want to look at all employees that started in, say, 2019, that's fine. I can get you'd want to look at all training that was done in, say, 2020, that's fine, but I can't really think of any sensible use to use a single slicer here unless you're wanting to say "I want to see all training done in 2019 by employees that started in 2019". Really think that any use for this sort of thing would use two slicers - what exactly do you want to do with just one slicer?
Exactly!
I have for example a page which has:
Hirings, Terminations, Trainings, Performance Results, etc
So i want to filter 2019 in all that visualizations in one time with one slicer.
In fact, i want my client to be able to use one slicer to filter all thatThanks
