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?
Hi Jurgen,
As far as I know, there are three options.
- Linking a shape to a calculation involving multiple parameters | DataMiner Docs
- This makes it possible to specify multiple parameters (possibly with a different filter). You can decide to take the minimum, maximum, sum or average value of all specified parameters. This is by design the most preferrable way, but is not the most flexible solution for more complex calculations.
- You can also make use of so-called placeholders, i.e. [Max:X,Y,Z], [Min:X,Y,Z], [Avg:X,Y,Z], [Sum:X,Y,Z]. This is much more because you can dynamically specify the desired values, however you are dependent on the placeholders available. For example, I wasn't able to find division or multiply (I might have overlooked).
- You can also make use of an Automation Script which offers all flexibility you desire, however it might be a bit slower than the default functionality you have within the Visio shape data. You can trigger the script by click of a shape or by page load.
Kind Regards,
Jarno
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?