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.

[Maja Vallin]

It could be that the function isn't activated for your space. 

If you go to your space, then select Administer space, then select General and Features. Then you should be able to enable Databases. If you don't have access you can ask the space admin to toggle it on

Best of luck!