Tag: amazon-timestream

In AWS Timestream I am trying to get the average heart rate for the first month since we have received heart rate samples for a specific user and the average for the last week. I’m having trouble with the query to get the first month part. When I try to use MIN(time) in the where clause I get the error:

I am storing measurements in Timestream with the following attributes (example): Let’s assume these metrics are written one per day. How do I have to query the data in order to get a monthly sum on the request count metric for a specific domain? In order to get a sum for the whole time range queried I can do this: