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?

@Lars_Andersson,

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,
Julia