I believe this is a bit advance (although I hope not). Hoping someone might be able to provide some guidance.
I have these entities called a "structure" and each structure has multiple and a varying number of entries by month. The attached data has data for months 1 to 5, and I'd like Alteryx to calculate the median by month of the fields "UNIT_PRICE" and "PRICE_OVER_COST" using the most recent three months of data. The results should be as follows (where the last column is a description and is not needed in the output generated by Alteryx)
Structure Month Median Price Median Price Over Cost Data used to Calculate Median
A 3 996.13 .70115 Months 1 - 3 for Structure A
A 4 1061.45 .74713 Months 2 - 4 for Structure A
A 5 1143.1 .80460 Months 3 - 5 for Structure A
B 3 962.27 .86075 Months 1 - 3 for Structure B
B 4 966.155 .86422 Months 2 - 4 for Structure B
B 5 1079.52 .94207 Months 3 - 5 for Structure B
Any guidance on how I can accomplish this? Data attached. Thanks all!
