Thingworx provides a library of InfoTable functions, one of the most powerful ones being DeriveFields (besides that I use Aggregate and Query a lot and ... getRowCount)
DeriveFields can generate additional columns to your InfoTable and fill that with values that can be derived from ... nearly anything! Hard coded, based on a Service you call, based on a Property Value, based on other values within the InfoTable you are adding the column to.
Just remember for this Service (as well as Aggregate), no spaces between different column definitions and use a , (comma) as separator.
Here are some two powerful examples:
//Calling another function using DeriveFields
//Note that the value thingTemplate is the actual value in the row of column thingTemplate!