I was using $dateTrunc on a timeseries collection to group the timeseries data from 2024-12-01 to 2024-12-07 into a single bin. Here is the aggregate pipeline: [ { $match: { timestamp: { $gte: ISODate('2024-12-01'), $lte: ISODate('2024-12-07'), }, } }, {…
I'm using MongoDB 7 to store data in a time series collection. When I find documents between a start and end some documents I'm sure are there (I can find them by _id) don't get retrieved, so I ran .validate()…
I have a question. I have the following scheme CREATE TABLE 'redirect3' ( id INT, short_url_id INT, browser SYMBOL capacity 256 CACHE, platform SYMBOL capacity 256 CACHE, os SYMBOL capacity 256 CACHE, referrer_domain VARCHAR, country SYMBOL capacity 256 CACHE, language…
I'm trying to run a DeepAR to do some estimation for a series the next 15 records based on current and previous months. I follow the examples and I believe that everything is ok. Still I have a very cryptic…
Sorry for the bump, I am still searching for a method to omit rows based on specific conditions though. Is it even possible? I'm tinkering in a tool called Grafana with the aim of one day creating useful visualizations, tapping…
Let's assume I have a table with 3 columns: Id, Value, date Time. I need to find the min, max, first and last value of each 1 minute window between the provided start and end time. And in case no…
I have a table: CREATE TABLE t_table ( c_id int4 NOT NULL, c_date_called int4 NOT NULL, CONSTRAINT t_table_un UNIQUE (c_id, c_date_called) ); that stores distinct snapshots of data, with data as such: INSERT INTO t_table (c_id, c_date_called) VALUES (1,9), (2,9),…
I'm writing a query in MySQL for a Grafana dashboard, but the performance of only this particular query is very poor. This is the query: SELECT br.reading ,CONCAT(ino.project,"_",SUBSTRING_INDEX(br.sensor,"_",-1)) AS new_metric ,ino.vessel ,ADDTIME(DATE('2023-01-01'),-TIMEDIFF(ino.date,br.datetime)) AS norm_date ,br.sensor FROM db.milestones br INNER JOIN…
I have following timeseries data table, Id Object_Id Datetime Sensor1 Sensor2 1 175 '2022-03-24 22:01:00' 0 0 2 175 '2022-03-24 22:02:00' 0 0 3 175 '2022-03-24 22:03:00' 5.5699381666667 81.342836833333 4 175 '2022-03-24 22:04:00' 5.5668366666667 81.281143 ... ... ... ... ...…
Say, I have 150 records spanned over 2 hours period, eg, 1am to 3pm. There are 60 records timestamped at the end of 1pm and 70 records timestamped at the beginning of the 2am. I need to produce a report…