How to add a dynamic filter to show last half of the year?

  • 1
  • Question
  • Updated 2 weeks ago
  • In Progress
How do we filter completed date = last half year 
eg : Completed date that falls within 2H17 or 1H18?
Photo of Jahnavi

Jahnavi, Champion

  • 1,756 Points 1k badge 2x thumb

Posted 3 weeks ago

  • 1
Photo of Tim Schukar

Tim Schukar, Employee

  • 914 Points 500 badge 2x thumb
Hey Jahnavi - 

If you want this to be dynamic, you could create the global filter for completed date = last N days and select 182 as the "N".  This would give you a trailing six months of completions.  Would that work?

Thanks.

Tim
Photo of Dan Ahrens

Dan Ahrens, Gainster (employee)

  • 22,658 Points 20k badge 2x thumb
I think Tim's on to the solution here. You can also use "Current and Previous Quarter" as a potential option to capture half year segments.
Photo of Jahnavi

Jahnavi, Champion

  • 1,756 Points 1k badge 2x thumb
Well, Thanks for both the solutions but I am looking at something which is 1st Jan to 30th June.

Last N days would be dynamic everyday 
CQ + PQ would also be dynamic