Good morning,
I am creating a spreadsheet in which I am using the MES Analysis Controller to generate the data.
It is as follows
data points: Hour Interval,Outfeed-BM1_Outfeed,Outfeed-BM2_Outfeed,Outfeed-BM3_Outfeed,Outfeed-BM4_Outfeed,Outfeed-BM5_Outfeed,Outfeed-BM6_Outfeed,Outfeed-BM7_Outfeed,Outfeed-BM8_Outfeed,Outfeed-BM9_Outfeed
Filter by: Equipment Path LIKE 'CanPack\Itumbiara\Cans\Line20\Bodymakers\BM*'
Group by: Hour Interval
It is generating these two columns for each piece of equipment correctly, hour interval and outfeed.
I would like to add a column for the failure counter for each piece of equipment by hour interval. I initially did this but only with another MES Analysis Controller, because I was unable to add the settings to the data points for it to work correctly.
data points I'm trying to add:
Hour Interval,Line Downtime Occurrence Count
Filter by that I'm using: Equipment Name = 'BM1' AND Equipment Path LIKE '[global]\CanPack\Itumbiara\Cans\Line20*' AND Equipment State Name = 'FLT PRX3 Short Can'
Thanks in advance.