SELECT name, avg(value) as entryBeltSpeed, time_bu...
# umh-support
d
SELECT name, avg(value) as entryBeltSpeed, time_bucket('$__interval', timestamp) AS time FROM tag WHERE asset_id = get_asset_id_immutable( 'Mayker', 'Ghent', 'DigitalTwin', 'PickAndPlace', 'Portal' ) AND name = 'MachineInfo$MachineSettings$entryBeltSpeed' AND $__timeFilter(timestamp) GROUP BY time, name ORDER BY time ASC;