What is the best way to do complex database table calculations and then display the result onto the display? I started by having a dynamic property in the window to store the value but I need to do an expression from multiple database queries. It seems like ignition doesn’t allow the combining of the two am I missing something obvious?
In this case you need to write a script that creates a new dataset from the calculated values. Take a look at the system.dataset.toDataSet function here:
Hopefully that will help you get started.