How can Rank My Orders by Item's earliest item shipment date

nppani

Hi Need help with a Table Transformer Query for the  following. Thanks for your time in advance.

Rank  Orders based on earliest Item Shipment Date. The data is stored in a single table.

Ord#      Item#      Ship Dt

--------------------------------

Order 1   Pen     01/08/2026    

Order 1   Book   03/20/2026    

Order 1   Bag     02/15/2026    

 

Order 2   Item 2   02/10/2026    

Order 2   Item 1   01/05/2026    

Order 2   Item 3   05/20/2026    

 

 

Output 

Ord #       Item #    Ship Dt        Rank

-------- -----------------------  ---

Order 1   Pen      01/08/2026    1

Order 1   Bag      02/15/2026    1

Order 1   Book    03/20/2026    1

Order 2   Item 1   01/05/2026    2

Order 2   Item 2   02/10/2026    2

Order 2   Item 3   05/20/2026    2

 

 

Maja Vallin

Hi there,

Instead of using a ordinary table in Confluence I would suggest to use a Confluence database that have a lot more functions than an ordinary table.

In the example down below I've used a field type date for the Shipping date and then used the sorting function to sort by earliest to latest. 

You have a bunch of other field options other than date and text field. If you have all this information stored somewhere today you could also do a import of that to a confluence database.

You have a lot of documentation here

Hope this helped you