Hello @GarreinBart-1885,
Thanks for the question & also for using the forum .
I just did a quick test and i am able to do max - min , off course in my case it was all dummy data . So ASA does support aggregate differences . It may be something else which is wrong in the query .
My query which worked is
with DDDdiff AS (
select
System.Timestamp() as processTime,
deviceid,
max(fitvalue) - min(fitvalue) as rangeOfValue
,max(fitvalue)
,min(fitvalue)
from [inputEH]
group by deviceid, HoppingWindow(second,600,10)
)
SELECT * FROM DDDdiff
Thanks Himanshu
Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members