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

Community Tip - Have a PTC product question you need answered fast? Chances are someone has asked it before. Learn about the community search. X

creating charts from the grid data

KSM
14-Alexandrite
14-Alexandrite

creating charts from the grid data

Version 1

Hello,

Am sending the json data through the Post method via rest API URL and it is displaying on grid by using getDataTabeEntries service. now i want to create a chart by using two columns of data from the grid on the mashup. but am unable to create anytype of chart by using that data.

i want to show the values  chart of sensor value of a temperature and timestamp .

can anybody please help me out?

9 REPLIES 9
aelgov
1-Newbie
(To:KSM)

Please try to elaborate more.

Are you trying to use time series chart?

Make sure you are binding the data to the correct place in the chart - data source.

Please add screenshots, it can help.

KSM
14-Alexandrite
14-Alexandrite
(To:aelgov)

Hello Assaf Elgov,

Thanks a lot for reply

I have attached the screen shots,

1 screen shot : The data is displayed on the grid, from that grid i want show the timestamp and sensor_2 value on the graph.

2. screenshot  : I have bind the data and you can able to see the connection also from the getDatatableEntries service. and in the property configuration, i can able to see only the time stamp field in x- axis but no other fields in the the data fields of y-axis

3 screen shot : i get empty graph with no single value.

aelgov
1-Newbie
(To:KSM)

Please specify in the service data shape for the infotable, then try to drag again, you should have options in the list

KSM
14-Alexandrite
14-Alexandrite
(To:aelgov)

My service returns the output nothing.

KSM
14-Alexandrite
14-Alexandrite
(To:aelgov)

i have defined the output to my service is "nothing".

I tried for the infotable also but its not working.

aelgov
1-Newbie
(To:KSM)

You need the output type to be infotable and also to set the data shape according to the data you are returning.

KSM
14-Alexandrite
14-Alexandrite
(To:aelgov)

this is my service code, when i send the data through rest API, my data will directly display on the grid on mashup. as you said i have put output to infotable and added data shape also.

var values = Things["Gettankdt"].CreateValues();

values.device_key = jsonData.device_key; //STRING

values.app_version = jsonData.app_version; //STRING

values.sensor_2 = jsonData.nodes[0].sensor_2; //STRING

values.sensor_3 = jsonData.nodes[1].sensor_2;

values.sensor_4 = jsonData.nodes[2].sensor_2;

values.sensor_5 = jsonData.nodes[3].sensor_2;

values.sensor_6 = jsonData.nodes[4].sensor_2;

values.client = jsonData.client; //STRING

values.node_no = jsonData.nodes[0].node_no;//STRING [Primary Key]

values.node_no1 = jsonData.nodes[1].node_no;

values.node_no2 = jsonData.nodes[2].node_no;

values.node_no3 = jsonData.nodes[3].node_no;

values.node_no4 = jsonData.nodes[4].node_no;

values.device_no = jsonData.device_no; //STRING

values.device_type = jsonData.device_type; //STRING

values.timestamp = jsonData.timestamp; //NUMBER

values.timestamp = values.timestamp *1000;

me.timestamp = values.timestamp;

me.sensor_2 = values.sensor_2;

me.sensor_3 = values.sensor_3

me.sensor_4 = values.sensor_4

me.sensor_5 = values.sensor_5

me.sensor_6 = values.sensor_6

var params = {

values : values,

};

var id = Things["Gettankdt"].AddOrUpdateDataTableEntry(params);

var params = {

infoTableName : "InfoTable",

dataShapeName : "Gettankdatashape"

};

// CreateInfoTableFromDataShape(infoTableName:STRING("InfoTable"), dataShapeName:STRING):INFOTABLE(Gettankdatashape)

var result = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape(params);

aelgov
1-Newbie
(To:KSM)

Can you take screen shot of the service output ?

KSM
14-Alexandrite
14-Alexandrite
(To:aelgov)

yes sure,

PFA for the screen shot of the service output

Top Tags