Help with picking max. qtr. for a max. year

Question

Can someone help me how to arrive at max. quarter for a max. year. In the below table, would like to arrive at Year 2022, Qtr. 1. When I use the summarize (using group by max. year & max. qtr.), I get both 2021 Q4 & 2022 Q. Thankyou.

TeamProd DateQtr.YearAKC12/1/202142,021AKC12/2/202142,021AKC12/3/202142,021AKC12/4/202142,021AKC12/5/202142,021AKC12/1/202142,020AKC12/2/202142,020AKC12/3/202142,020AKC12/4/202142,020AKC12/5/202142,020AKC1/1/202212,022AKC1/2/202212,022AKC1/3/202212,022AKC1/4/202212,022AKC1/5/202212,022

atcodedog05 · Answer

Hi @MROGK

You don't need to convert the date or use the formula tool at all you can just sort by year (descending) sort by qtr (descending) and only keep the first row.

Hope this helps : )

quarters.yxmd

Qiu · Answer

@MROGK 
I try to avoid the DateTime formula.

0104-MROGK.yxmd

apathetichell · Answer

so you want Team as well? You didn't ask for it. Take you datastream after the date/time tool and join it to the stream coming out of the formula tool. Join on the datetimeout and the max date field. The join anchor will be any entries matching the max date.