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…
I've have a Postgres database and I'm using Grafana to visualise some data. For instance, my Grafana panel has the following variables where the values are dynamic: $__timeFrom() = '2023-10-21T00:00:00Z' $__timeTo() = '2023-10-21T00:25:00Z' $__interval = '15m' These variables are used…
In Postgres, given a collection of date ranges like: meter_id device_id start_at end_at meter1 device1 2020-01-02 10:30 2025-01-02 14:00 meter2 device1 2020-01-02 10:30 2020-01-02 11:30 meter3 device1 2020-01-02 10:30 2020-01-03 11:30 I want to bucket the ranges into: a range…