Skip to main content
Solved

Date Filter - Current & Previous 2 or 3 Quarters

  • May 20, 2021
  • 3 replies
  • 94 views

Robert_DeLaO
Forum|alt.badge.img+2

Hi team, I would be interested in seeing an option to filter dates with Current and Previous 2 or 3 quarters.  Currently I can only do Current and Previous Quarter (doesn’t go back far enough) or Last N Quarters (excludes current quarter). These options exist for future quarters but not for past ones.

 

The use case is for our onboarding team to track adoption health by quarter for customers who purchased in the current and previous 2 quarters. 

Best answer by Robert_DeLaO

Apologies. This can be deleted. I just realized that I can use the operator >= to get  the desired result.

3 replies

Robert_DeLaO
Forum|alt.badge.img+2
  • Author
  • Helper ⭐️
  • Answer
  • May 20, 2021

Apologies. This can be deleted. I just realized that I can use the operator >= to get  the desired result.


sai_ram
Forum|alt.badge.img+1
  • Expert ⭐️⭐️
  • May 21, 2021

Apologies. This can be deleted. I just realized that I can use the operator >= to get  the desired result.

@Robert_DeLaO awesome, thanks for the update!


HollySimmons
Forum|alt.badge.img+1
  • Helper ⭐️
  • July 14, 2021

@Robert_DeLaO Note that they’ve removed these filter options in Horizon, please add a vote here to bring them back;
 

 

Thank you!