how to find out oldest item by status?

asish lamichhane

I have a table that has fields like following

I need to create a metrics, that shows only the lines with oldest age of each statuses.

How can i create such metrics?

Paul H

Try This

Add a new checkbox column and use this as its column formula.

=IF([last activity on support ticket]@row = MIN(COLLECT([last activity on support ticket]:[last activity on support ticket], Status:Status, Status@row)),1)

This should checkmark the only the oldest