Find most recent transaction - Dataset View

swagner
swagner Contributor
in Magic ETL

I have a dataset with item receipt dates by branch. I need to find the most recent receiving event for each item by branch. The dataset has about 7M rows, and my thought was to do a dataset view, rank the receipts by branch & item descending on the receipt date. I can't seem to get the calculated column to work.

Any help would be appreciated.

rank() over(partition by Branch, Item order by Receipt Date desc)


Picture1.png


Comments

  • jaeW_at_Onyx
    jaeW_at_Onyx Coach
    edited August 2022

    @swagner why didn't you @ mention me? sorry so late to the party!

    sum(sum(1)) over ( partition by branch, item order by receipt date desc)

    shoudl work i believe.

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • swagner
    swagner Contributor

    @jaeW_at_Onyx thanks for the response! Much appreciated!

Categories