Forum Discussion
Matching values between 2 tables when using a date slicer
Hi,
Your data does not seem reepesentative. You have taken only 1 date - please take more dates as well. Also, within the date range selected, what is an employee visited on a certain date and not on another. In such a scenario, since in the result, the employee ID should appear only once, what should the result be - Yes or No. As requested, please share a logical/resresentative example and show the expected result on that revised sample.
Hi
My solution and im not sure if it can be acheived would be to dynamically show on the employee table if they had and didnt have visits when the date is sliced.
It would not matter if they had 1 visit in a 1,2 ,3 or x number of days. The result would expect to show " has visit".
Conversely, the result if they do not have a visit in a 1,2,3 or x number of days should show "no visit".
My employee count is approx 160 and depending on how big or small the date slicer is i could expect for a 1 day range, 120 employees scheduled and 40 not scheduled. So , i want to be able to show which employees had visits and which ones didnt in this date range.
Examples attached restricted to a select few employees along with a select few visit on different dates.
https://docs.google.com/spreadsheets/d/1aaWM9OeGhi7sPeoucvZ3UakpLM5_R-ugcFyJWwmij2E/edit?usp=sharing
Perfect
Exactly what i was looking for
You are welcome.