Community Tip - Learn all about PTC Community Badges. Engage with PTC and see how many you can earn! X
Hi. Now I am doing single aggregate function for real data and I want to proceed to multiple field aggregate function. Like I want to calculate each target and real data number for average using one service because I want to show both of them in one label chart. how to combine them in one service?
var result = Resources["InfoTableFunctions"].RenameField({ t: Resources["InfoTableFunctions"].Aggregate({ t: me.QueryDataTableEntries({ maxItems: undefined, query: query, values:undefined, source: undefined, tags:undefined }), columns: 'value,Target', aggregates: 'AVERAGE', groupByColumns: 'month' }), from: "AVERAGE_value,AVERAGE_Target", to: "value,Target" });
After that, thingworx will show Error executing service QueryByMonth_Cost_Cheese_OE_LineA. Message:: Wrapped java.lang.NullPointerException - See Script Error Log for more details