Custom Filter

[Tame]

Hello -

 my current dataset has 5 years (2018-2022) of data and it is also broken down by quarters. I will receive 2023 data soon. 

How do i create a custom filter to show year 2022 and Q2,Q3 & Q4. When I get 2023 data I will need to Drop Q2 Then use Q3,Q4, and Q1 on 2023 and the cycle continues. Each qrt, the older qrt gets drop.

[Raj]

share some sample data as input and required output

[Tame]

so the basic filter only gives me one condition. I would like to use the custom filter to select both qrt and year. 

[Yoshiro_Fujimori]

Hi @Tame ,

It would be easier to handle to convert quarter to serial number, counting from a certain point of time.

Input

Workflow

Formula

Serial_Quarter = ([Year]-2021) * 4 + [Quarter]

Current_Serial_Quarter

  = (DateTimeYear(DateTimeNow()) - 2021) * 4
  + CEIL(DateTimeMonth(DateTimeNow()) / 3)

Output

I hope this may be of some help.

Good luck.

[Tame]

Thank you Yoshiro I will try this!

[Raj]

If the data looks like this you can try this as well

[Tame]

Thank you :)