Repeated events over a certain amount of time = flag

[charlienhill]

Hey team, this is likely answered elsewhere, so feel free to just point me to it.

I need to produce a report of devices that report a certain data point repeatedly over a certain amount of time.

Example: if a thermostat reports >80deg for 3 of the 4 past reporting periods, that = a sustained high-temperature condition.

Can someone direct me on how to achieve this?
Thanks

[reed_rawlings]

Hey Charlie,

Would it be possible to pivot on the reporting time with your data points acting as a measure and then using a table calculation to check the condition?

An example condition check might look like,

if(sum(pivot_row(${order_items.count})) > 50, yes, no)