How to use SQL-Timeseries time bucket to aggregate a table and also return a FK of the greatest row
Given the table (hypertable) with the columns peripheral (FK), data point type (FK), time and value, can the peripheral and/or data point type be included with each maximum aggregate? Can the top n (like top 3) FKs be included?