Extracting the latest quarter value - Slice_tail (n=1) equivalent for Alteryx

Question

Hey everyone, I am transferring over from R Studio and trying to figure out a procedure I used to perform there. Basically I have a lot of different lines of business with earnings reported starting 2014 on a quarterly basis. I am trying to get the latest values. So my data looks like the following and the values I want to extract are the ones highlighted

In R - dplyr, I can use group_by function to group different variables together then use slice_tail(n=1) to get the last value based on the groups I created. Is there something similar in Alteryx?

Thanks in advance!

Clifford_Coon · Accepted Answer

Hi, not that I'm aware of in a single tool,

You could sum group by Segments, max Qtr_Count, then join back to original.