cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - New to the community? Learn how to post a question and get help from PTC and industry experts! X

Number of rows in Thingworx Analytics has a value of zero

Nuttapol
11-Garnet

Number of rows in Thingworx Analytics has a value of zero

When i generate a new dataset, the number of rows tab has a value of zero

analytic.png

  These are CSV File and json code

  

[

{

        "dataType": "DOUBLE",

        "description": "C",

        "displayOnly": false,

        "fieldName": "C",

        "lever": false,

        "objective": false

},

{

        "dataType": "DOUBLE",

        "description": "D",

        "displayOnly": false,

        "fieldName": "D",

        "lever": false,

        "objective": false

},

{

        "dataType": "DOUBLE",

        "description": "E",

        "displayOnly": false,

        "fieldName": "E",

        "lever": false,

        "objective": false

},

{

        "dataType": "DOUBLE",

        "description": "F",

        "displayOnly": false,

        "fieldName": "F",

        "lever": false,

        "objective": false

}

]

1 ACCEPTED SOLUTION

Accepted Solutions
cmorfin
19-Tanzanite
(To:Nuttapol)

Hi Nuttapol

The issue (or at least one that woudl lead to 0 rows showing) is that you have no field defined as goal in the json file.

You need to have at least one field defined as goal ("objective": true ), so that the engine knows what to predict.

Without a goal, the dataset is indeed loaded as 0 rows.

Hope this helps

Kind regards

Christophe

View solution in original post

5 REPLIES 5
jgreiner
12-Amethyst
(To:Nuttapol)

Hi Nuttapol,

I have 2 questions to help me troubleshoot this issue:

  1. what version of ThingWorx Analytics Builder are you using?
  2. Are there any errors in the Application Log file in you ThingWorx Composer?

Thanks and Please Advise,

John

John GreinerThank you for answer

1. I use trial version

2. It don't have update log file when i  upload dataset

cmorfin
19-Tanzanite
(To:Nuttapol)

Hi Nuttapol

The issue (or at least one that woudl lead to 0 rows showing) is that you have no field defined as goal in the json file.

You need to have at least one field defined as goal ("objective": true ), so that the engine knows what to predict.

Without a goal, the dataset is indeed loaded as 0 rows.

Hope this helps

Kind regards

Christophe

Thank you so much Christophe Morfin

cmorfin
19-Tanzanite
(To:Nuttapol)

Hi Nuttapol

I am happy it worked for you.

If you do not mind, it would be useful if you could mark the reply as correct answer so that others facing the same issue will be able to easily find the solution.

Thank you

Kind rgeards

Christophe

Top Tags