Forum Discussion
Highlight dates in calendar table
Hi Anonymous ,
With that specific visual, I think you would just put [From] in 'Start date', [Until] in 'End date', and [Name] in 'Events'.
If you have another field in your table for Department, for example, you could put that into 'Event Group' to colour-code people in the same department.
Pete
Hi Anonymous ,
With that specific visual, I think you would just put [From] in 'Start date', [Until] in 'End date', and [Name] in 'Events'.
If you have another field in your table for Department, for example, you could put that into 'Event Group' to colour-code people in the same department.
Pete
BA_Pete Thanks for your help!
Just another question (please let me know if i should create a new topic for this) but it relates to the same table - how to do the reverse? So, display the same information in a calendar table but instead, highlight the opposite dates? I mean, all dates not shown in the range corresponding to each person. Thanks.
Hi Anonymous ,
I think you would need to create a list of all dates, join it with your employee dates table then, anywhere where a date had no employee against it, you would add "No one scheduled" as an event in another column (something like 'if [employee] = null then "No one scheduled" else null]). You could then filter on this value to leave only dates where no one was scheduled. You would then put your date column into the From field, and your new column in the Event field.
Pete