Enable aggregate query (Min, Max) on timestamp typed properties

Hi @Marissa!

Thank you for suggesting this product idea. We will follow the traction this idea gets in the community. You can expect updates on this post if we decide to include this in our future roadmap, or if we require more information.

Hey Marissa! You’re right that currently you cannot aggregate on timestamp properties in Data Modeling, however, for you specific use case, assuming the timestamp is a property defined by you (and not one of the automatically populated `createdTime` and `lastUpdatedTime`) you should be able to construct a query that

1. Gets all instances
2. Sort by timestamp, descending
3. Limit to 1

In this way you should be able to get the latest date. Here’s an example from GraphQL, that will return only the latest timestamp:

query MostRecentActivity {
  listCogniteActivity(first: 1, sort: {startTime: DESC_NULLS_LAST}) {
    items {
      startTime
    }
  }
}

Hi @kelvin,

Unfortunately, this doesn’t work in my case because I need to get the latest activity grouped by another field. E.g.: a user has an access history for multiple sites, so I want to get the latest activity per website for this user.