Skip to Main Content
Preset Feature Feedback
Status Needs review
Categories Enhancement
Created by Daniel Watania
Created on Jul 24, 2024

Add 'previous calendar quarter' to the Previous time range filter option

What is the problem or goal the end user is trying to solve or accomplish?

Users would like to filter a date range for the previous quarter. However, the option is not available in the Previous time range option list. The Last quarter option is counting -90 days from the current date.

How are they solving it currently?

Use this syntax on the Advanced time range filter:
- datetrunc(dateadd(datetime("today"), -3, month), month)
- datetrunc(datetime("today"), month) (use the first date of the month as the end date is exclusive)

Or manually input the date.

What is the recommended solution by the Customer?

Create the option of previous calendar quarter to the Previous time range filter.

  • Attach files
  • +1