Skip to main content
Nuttapol12-Amethyst
12-Amethyst
October 27, 2017
Solved

Number of rows in Thingworx Analytics has a value of zero

  • October 27, 2017
  • 5 replies
  • 2957 views

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

}

]

Best answer by cmorfin

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

jgreiner13-Aquamarine
13-Aquamarine
October 27, 2017

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

Nuttapol12-AmethystAuthor
12-Amethyst
October 31, 2017

John GreinerThank you for answer

1. I use trial version

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

cmorfin19-TanzaniteAnswer
19-Tanzanite
October 31, 2017

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

Terms & ConditionsAccessibility statement