Math Extensions for Ignition

[justinedwards.jle]

@kavya_shree

do total of column values in a power Table.

I recently posted a couple of examples of this here:

Display sum of a column at the end of the table

There are at least two approaches that would work here. You could write a second select statement that automatically generates the sums, and then append it to the last row of your existing query with a union. In this way, the data comes directly from the query with no intermediary scripting required. The query would look something like this:

Sample Query

SELECT EquipmentName as 'Machine No', ShiftID as 'Shift', TIME_FORMAT(SEC_TO_TIME( SUM(CASE WHEN StateChangeFrom = …