Find most recent transaction - Dataset View

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)



Comments

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR πŸ”΄
    edited August 29

    @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 🟒

    @jaeW_at_Onyx thanks for the response! Much appreciated!