Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Using Max date and filtering to max fiscal quarter MINUS 1 to ensure a complete quarter?

Dan5
8 - Asteroid

Hi All, 

 

I have a function that filters records by max date, which i calculate using the summary tool on fiscal quarter (ex: 2021 Q3, 😞

 

[Snapshot Fiscal Quarter]=[Max_Snapshot Fiscal Quarter]

 

I am running into issues where the max year/quarter is in the current quarter, which may be incomplete still, so i would like to filter to "max-1", to ensure I have the most recent closed quarter. 

 

How can I write this filter, given my date format above? Ideally, so it doesnt break as we roll into new years down the line. 

2 REPLIES 2
Emil_Kos
17 - Castor
17 - Castor

Hi @Dan5,

 

Just group the records by Quarters and pick the second one. Append this to the data and you will be able to use it as a filter

 

Emil_Kos_0-1615298258847.png

 

Dan5
8 - Asteroid

thanks, nice solution!

Labels