I have raw tags:
Requirements are:
a) user enters Hours. b) Based on hours I get a value of "Max" in those hours and a Value of "St Dev" during the given time period.
Please see image: Desired Result
Database is stored as following schema:
I have raw tags:
Requirements are:
a) user enters Hours. b) Based on hours I get a value of "Max" in those hours and a Value of "St Dev" during the given time period.
Please see image: Desired Result
Database is stored as following schema:
You'll want to use an Expression Tag for this. Check out Ignition's video on this: Creating Expression Tags. You link "Desired Result" is an image of a database schema, not the desired result. If you update that image I can help you further. You want to use one expression tag for the Max value in your data, and another expression tag for the St. Dev. in your data.