Skip to main content
P
PErhams1-Visitor
1-Visitor
March 26, 2018
Solved

Json file for categorical input to Thingworx Analytics

  • March 26, 2018
  • 3 replies
  • 3275 views

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.

 

 

 

Best answer by cmorfin

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

 

3 replies

C
cmorfin19-TanzaniteAnswer
19-Tanzanite
March 26, 2018

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

 

    C
    cmorfin19-Tanzanite
    19-Tanzanite
    March 28, 2018

    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

    L
    LeighEmeritus
    Emeritus
    April 5, 2018

    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

    Terms & ConditionsAccessibility statement