Best way to get Mode per season/region + keep custom size order?
Erik Johansen
I'm New Here 
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Goal: Import fashion sales JSON (nested fields for item.attributes.size/color, enums for season, etc.), group by season → region, and use Mode to find the most frequent size and color.
Question: What’s the cleanest way in Simple Tables to keep a custom size order (XS < S < M < L < XL) and show friendly labels (e.g., “Spring–Summer 2024” for “SS24”)? Should I add a calculated column that maps sort index + display label, or is there a better built-in approach?
1 answer
Bill Sheboy
Rising Star 
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.