Perspective Table Calculated Rows from MES OEE Dataset

Ignition
1

Hello - New to Ignition and Sepasoft. We are using Ignition version 8.1.37 and MES OEE Downtime 3.81.10.

For dashboarding purposes, we would like to take data received from a dataset from the MESController object and display it on a Ignition Table Component, but modify a column to multiply by a tag (Target OEE%) that is set by the user on a separate interface.

So our query from the MES Analysis Controller selects by hour the OEE, the Theoretical Outfeed Standard Count (Ideal Units Produced), and the OEE Outfeed Count (Actual units produced). This is presented in the props.data dataset and we use this to display in the table.

This works as expected.

I would like to multiply the Theoretical Outfeed Standard Count (Ideal Units Produced) by our TargetOEE tag (usually set at 70%) to display the Target Units Produced in the table. I don't see a way to do this in the Table Properties. Can anyone help? I'm also interested in other data manipulation in the table once I figure this out - such as dashes or null for hours that we are not producing anything and it defaults to 100%.

Thanks!
Ben

2

A short answer:

  • Create a CUSTOM.data property on the table and bind that to the raw data source.
  • Create a Property Binding on the table's PROPS.data and point it to the custom property defined above. (Use the Browse Properties button to select it so that you don't goof up.)
  • Add a Script Transform to the PROPS.data property binding to manipulate your dataset as you want.

See how far you get with that and if you're in bother then post your script here. Please see Wiki - how to post code on this forum.

3

Thank you, that worked - here is the code that I utilized. Please let me know if there is something I should have or might have done differently:

def transform(self, value, quality, timestamp):
	TargetOEE = system.tag.readBlocking("[OEETAGS]/Targets/OATarget")[0].value*.01
	pydset = system.dataset.toPyDataSet(value)
	returned_rows = []
	for row in pydset:
		row_dict = {}
		row_dict['Hour'] = row['Hour Interval']
		row_dict['Target Vials'] = int(row['Theoretical Outfeed Standard Count']*TargetOEE)
		row_dict['Actual Vials'] = int(row['OEE Outfeed Count'])
		OA = row['OEE']
		TargetVials = row['Theoretical Outfeed Standard Count']
		if TargetVials > 0:
			if OA > TargetOEE:
				OA = {'value': OA, 'style': {'backgroundColor':'#43FF00'}}	
			else:
				OA = {'value': OA, 'style': {'backgroundColor':'#F86452'}}
		else:
			OA = {'value': "--", 'style': {'backgroundColor': '#D5D5D5'}}
		row_dict['OA']=OA
		returned_rows.append(row_dict)
	return returned_rows
1 Like
4

I am getting an Invalid Key warning message for all of the Actual Vials and Target Vials in each array element.

image
image472×160 12.6 KB

Do you know why that would be happening?

5

Eliminate the space. Generally, keys need to be valid Python Identifiers. I would suggest replacing the space with an Under score, and then define the column headers in the columns section of the tables props.

1 Like
6

Perfect - thank you!