Skip to main content
Question

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


jahnavi
Forum|alt.badge.img
  • Contributor ⭐️⭐️⭐️⭐️⭐️
  • 67 replies
How do we filter completed date = last half year 
eg : Completed date that falls within 2H17 or 1H18?

6 replies

tim_schukar
  • Helper ⭐️⭐️⭐️
  • 78 replies
  • June 12, 2018
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

dan_ahrens
Forum|alt.badge.img+2
  • Expert ⭐️⭐️⭐️
  • 1984 replies
  • June 12, 2018
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.

jahnavi
Forum|alt.badge.img
  • Author
  • Contributor ⭐️⭐️⭐️⭐️⭐️
  • 67 replies
  • June 13, 2018
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

dan_ahrens
Forum|alt.badge.img+2
  • Expert ⭐️⭐️⭐️
  • 1984 replies
  • July 23, 2018
Hi Jahnavi - how often would this filter need to change and what would trigger the changing of the filtered dates?

jahnavi
Forum|alt.badge.img
  • Author
  • Contributor ⭐️⭐️⭐️⭐️⭐️
  • 67 replies
  • July 25, 2018
In our case the we want to calculate x occurrences for current half year which is July 1- Dec 30 for 2018. As soon as we go to 2019 I would need to change the dates for all reports

dan_ahrens
Forum|alt.badge.img+2
  • Expert ⭐️⭐️⭐️
  • 1984 replies
  • July 25, 2018
Hi Jahnavi, yes, if you want to set a custom date range we have a "between" and "custom" filter criteria. 

The best way to do this so that you don't have to change the filters for all the reports is to set a Dashboard Filter where you define the custom date range. This way all the reports on that Dashboard will reflect that date range without you having to change the dates for all the reports.

See example below:


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings