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

Number of rows in Thingworx Analytics has a value of zero

SOLVED
Level 5

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

Re: Number of rows in Thingworx Analytics has a value of zero

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

5 REPLIES 5

Re: Number of rows in Thingworx Analytics has a value of zero

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

Re: Number of rows in Thingworx Analytics has a value of zero

John GreinerThank you for answer

1. I use trial version

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

Re: Number of rows in Thingworx Analytics has a value of zero

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

Re: Number of rows in Thingworx Analytics has a value of zero

Thank you so much Christophe Morfin

Re: Number of rows in Thingworx Analytics has a value of zero

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