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;