Write a query in Cosmos DB SQL Api to select the Average value on every 20 mins of interval

HimanshuRawat-0925 6

I have a cosmos DB database by name db1. I want to write an Cosmos DB SQL query to select the average value after every 20 mins of interval.

Sample Database values : (although data in cosmos DB is visualized in JSON format.)

And the Output we want

GeethaThatipatri-MSFT 29,587 Reputation points Microsoft Employee Moderator

2022-04-29T16:50:42.397+00:00

Hi, @HimanshuRawat-0925 Welcome to the Microsoft Q&A forum, and thanks for reaching out.
Can you please be more specific on your query? so I can better assist you.

Regards
Geetha
GeethaThatipatri-MSFT 29,587 Reputation points Microsoft Employee Moderator

2022-05-02T15:55:25.96+00:00

Hi, @HimanshuRawat-0925 We haven't heard back from you. Just wanted to check if you are still facing the issue? In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Regards
Geetha
HimanshuRawat-0925 6 Reputation points

2022-05-03T08:01:42.38+00:00

Thanks, @GeethaThatipatri-MSFT for responding.

Well, I have a container in Cosmos Db by name db1.
And I am writing a query in SQL API to get the data in a specific time range
Query :

SELECT db1.value,db1.timestamp
FROM db1
where db1.timestamp BETWEEN '2022-04-28T07:10:00.00Z' AND '2022-04-28T08:20:00.00Z'

And Output I get is,

But I wanted to write a query, that gives us an average of "value" on every 20 mins of interval.

And output should look like,

Thanks and Regards,
Himanshu Rawat

Your answer