How do I create a column containing the max number from a ranked column?

user14700
user14700 ⚪️
in Magic ETL

I'm creating an ETL and need to create a column that lists the highest value from another column that lists ranking. If it helps, the ranking is based on date created on. Something that looks like this:

 

Screen Shot 2019-05-20 at 2.52.23 PM.png

Best Answer

  • ST_-Superman-_
    ST_-Superman-_ 🔴
    Answer ✓

    Because you are looking for the max value, I am going to recommend using the Group By tile.

    1.png

     

    2.png

     

    3.png

     

    4.png

     


    ______________________________________________________________________________________________
    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
    ______________________________________________________________________________________________

Categories