Is it possible to make calculations based on a single field in a sensor table within a Visio view?
I'd like to create an overview of the power consumption across our site but would want to convert current to power and in case of a 3 phase feed would like to total the power per 3 phases while measuring per phase.
How can i distill a single field (e.g. Value raw for index 3) in a table, make a calculation with it and show the outcome in a Visio view?
Placeholders are where it's at for this one.
- Retrieve the Specific Field: Use the
[param:]placeholder to retrieve the value of a specific table column. For example, you can use[param:DmaID/ElementID,TableParameterID]to reference a specific parameter in a table. - Perform Calculations: We have some other placeholders that allow you to do simple calculations on things (look for sum, subtract...). If you add your param placeholder inside this one as one of the values you should be able to do what you want.
Combining these placeholders and placing them in your shape text should move you along a fair bit.
If your multiplication is a static amount of times, you could work around it by summing the same number that amount of times. We have had no use cases come our way to multiply until now, hence why we have no placeholder for it. Alternatively, you could use the Execute page data to trigger a script that outputs a session variable. In there you can do pretty much whatever you want, but that's of course a big workaround.
Thank you Toon. Any idea how i could multiply using placeholders?