One Day Filter

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 

Z
Zoltan Palffy 👤 Member for 16 years 10 months

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

 

S
Santosh Bhat 👤 Member for 21 years 1 month

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:

  • 1: Started before 1-Dec and will finish after 1-Dec. ie. in progress
  • 2: Started before 1-Dec, but will finish on 1-Dec
  • 3: Starts on 1-Dec and will finish after 1-Dec
  • 4: Starts and Finishes on 1-Dec

Your filters will need to be (OR) for all the above scenarios.

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts