Skip to main content
A
apineda1-Visitor
1-Visitor
October 26, 2015
Question

Formulas in streams?

  • October 26, 2015
  • 2 replies
  • 2325 views

Hi,

I was wondering if ThingWorx supports an automated column defined by a formula akin to adding formulas to columns in Excel tables.

I have data in raw forms such as voltage but I would like to convert these values to something more meaningful like temperature, barometric pressure, flow rate, etc.

Thanks!

2 replies

B
byutz1-Visitor
1-Visitor
October 26, 2015

Hi Alister,

I have not seen a way to put a formula in a stream directly, but you could write a service to do a calculation everytime a stream entry is made.  You could have the service add a column and make your calculation.

    A
    apineda1-VisitorAuthor
    1-Visitor
    October 26, 2015

    That's basically what I have done so far. It would be nice to have something more dynamic in case the expression changes for whatever reason.

    C
    CarlesColl1-Visitor
    1-Visitor
    October 26, 2015

    The other way around, it's to make a service which executes the stored or in service formula, and returns the new columns, attached to current stream entries, you just need to AddField and/or use Derived functions.

    Carles.

    Terms & ConditionsAccessibility statement