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

[Marc -Devoteam-]

Hi @nppani 

Are you using a 3rd party app in your Confluence instance.

I think you do, as you mention the table transformer function?

@Stiltsoft support I suspect the Table, Filter and Charts app is used, could you assist?

[nppani]

Hi Marc, we are not using third party table tools nor Stiltsoft.

[Marc -Devoteam-]

Hi @nppani 

So if you don't.

The look at the option from @Maja Vallin to start using a database in Confluence, as ootb there is not table filer in Confluence to achieve your require,ment.

[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

[nppani]

Hi Maja,  I cannot use Confluence database. 

[Marc -Devoteam-]

Hi @nppani 

Yes you can, select the + sign and the option to create a database.

[nppani]

I don't have any database related options.

[nppani]

Our confluence is pretty locked-down version.