Json file for categorical input to Thingworx Analytics

[PErhams]

Hi,

I'm currently trying to use ThingWorx Analytics in order to predict the throughput and bottlenecks depending on what the variant mix looks like for a set time interval. The input to the model i categorical which works just fine with the json format:

"fieldName": "Order 1",
"dataType": "INTEGER",
"opType": "CATEGORICAL"

However, the only output/goal that seems to be allowed is continouos. For some reason i just can't format the categorical or ordinal output/goal from the mode. I doesn't even show up as an alternative in the goal list unless it is continouos. I've tried several different ways, all based on this post: https://community.ptc.com/t5/IoT-AR-Tech-Tips/Metadata-in-ThingWorx-Analytics-8-1/m-p/535321#M24. I've tried to use categorical with or without values, and i've tried ordinal with several different values.

Here are two examples i think should've worked for Throughput and Bottleneck detection respectivley:

"fieldName": "Throughput",
"dataType": "STRING",
"opType": "ORDINAL",
"values": ["LOW", "MEDIUM", "HIGH"]

"fieldName": "Primary Bottleneck",
"dataType": "STRING",
"opType": "CATEGORICAL"

I've tried to give throughput numerical ranges aswell, but to no success. I hope someone has some input on the matter.

Thanks in advance.

[cmorfin · Accepted solution]

Hi

ThingWorx Analytics Builder does not currently support Categorical and Ordinal goal, this is why you do not see them listed under the goal list.

However ThingWorx Analytics Server is capable of handling them (this is only Builder, the UI part which does not support them).

To make use of them you therefore need to use the services of AnalyticsServer_TrainingThing (CreateJob) and AnalyticsServer_PredictionThing (RealtimeScore or BatchScore) to generate the training model and then score new data.

This can be done either by creating your own new mashup or using REST API.
https://www.ptc.com/en/support/article?n=CS271485 can be of interest for the REST API part.

Hope this helps

Kind regards

Christophe

[cmorfin]

Note  https://community.ptc.com/t5/IoT-AR-Tech-Tips/How-to-work-with-ordinal-and-categorical-data-in-ThingWorx/m-p/542406 can also be of interest on how to use the thing/s services in a mashup

[Leigh]

Hi @PErhams

Just wanted to follow up to see if Christophe's responses answered your question.  If so, please indicate the Accepted Solution for the benefit of all of our Community users.  If not, please advise on your current status.

Thanks!

Leigh