Adding a column called min and assigning its value finding the min by group

Question

Hi there, new user and just getting to grips with everything, just wondering what best practice would be for adding a new column to an input dataset which needs to go through the records by group (market_id) and looks up the min value in (sales) for each of those groups

I have seen examples using Summarize and then join back on but I was wondering if there is any other way, like using the formula feature  that you could recommend I research into ?

Cheers in advance,

Rob

robertporternz · Answer

Awesome , thanks for this example, really handy,  so its a sort ascending and then select first record , really cool example and then adding it into the join

robertporternz · Answer

Cheers, I can build the sql statement ,I'm just not sure if there is a tool that I should be using it in, "Formula" sounded likely but no from what I've read so far.

atcodedog05 · Answer

Hi @robertporternz

The chances of you getting a sql based solution here is low.