Query with filter

I have a times series value, lets call it X that varied between 0-100.
If I wanted to calculate the average of X for the past hour, but only use values if they are above 5.
Can that be done?


When you say “use values” what do you mean? Do you only want to display values above 5 in the Dashboard? Or you want to filter the list within a Workflow and use them within the Workflow Engine?

Sorry, I didn’t explain very well.
Within the workflow.
Just want values above 5 to be the base for the average.

Hi @Lars_Andersson,

This functionality is not currently available out-of-the-box within Losant. At the moment, you would need to use a workflow to request the data for the past hour. You would then use a Function Node to do the aggregation manually, ignoring values below 5. You could also use a Loop Node with a Conditional Node and a few Math Nodes, but the Function Node will likely prove simpler.

Please let me know if you have any further questions,