Hello All!
More help needed......
I'm trying to create a filter that I can use daily to do a vertical slice of just the activities that are happening on a specific day.
Here's what I have so far but I'm not sure what I'm missing:
Activity Status not equal to Completed
Start equals Dec 1
Finish is great than or equal to Dec 1
glad I could help
Excellent! Thanks - I got it to work!
you did not say if Dec 1 was the data date or a date in the future so
filter
where
Activity status is not equal to complete
or
Start is less than or equal to Dec 1
or
Finish equals Dec 1
Heather, that wont capture activities that have started before 1st December and are currently in progress.
There are four scenarios that can happen on that day:
Your filters will need to be (OR) for all the above scenarios.