# Add column to a table using the MES Analysis Controller **URL:** \ **Category:** Ignition\ **Tags:** ignition79\ **Created:** [August 1, 2024, 2:00pm UTC](https://forum.inductiveautomation.com/t/add-column-to-a-table-using-the-mes-analysis-controller/94042 "2024-08-01T14:00:34Z")\ **Posts on this page:** 1\ **Page:** 1
**Author:** ![Renato\_Campos](https://avatars.discourse-cdn.com/v4/letter/r/5fc32e/32.png) [@Renato\_Campos](https://forum.inductiveautomation.com/u/Renato_Campos)\ **Post date:** [August 1, 2024, 2:00pm UTC](https://forum.inductiveautomation.com/t/add-column-to-a-table-using-the-mes-analysis-controller/94042/1 "2024-08-01T14:00:35Z")
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' ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/f/5fdb92a255e59761ded428d61479ae7086947bde.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/5/a5ff649e39bb55bc80d000bea5250a19e2c5b82a.png) Thanks in advance.