Skip to main content
A
Aditya170216-Pearl
16-Pearl
April 10, 2024
Solved

Pie chart Widget not working

  • April 10, 2024
  • 1 reply
  • 2489 views

Hello,

Good Morning,

 

I am trying to use pie chart widget in thingworx mashup, but not able to achieve the output.

 

I have a service which has infotable as an output(Service.png). I have bound all data of that service to pie-chart widget(Binding.png) in thingworx mashup. After viewing the mashup it says no data in mashup(Mashup.png).

 

I have attached the reference images, can anyone help me out with the same.

 

Thanks in Advance.

 

Regards,

Aditya Gupta 

Best answer by Rocko

What your service returns (columns StepStatus  and COUNT_StepStatus) does not match the Datashape you defined as shape for the result infotable. Those need to match because in a mashup, you can only bind the fields defined in the Shape, not the ones that are actually returned by the service. In your case it might be the easiest after the aggregate to Run to RenameField service so the infotable columns match the ones from the datashape.

result.

Resources["InfoTableFunctions"].RenameField({t: result, from: "StepStatus", to: "PropertyName"});
Resources["InfoTableFunctions"].RenameField({t: result, from: "COUNT_StepStatus", to: "Count"});

 

In your mashup, bind "All Data" from the service to "Data" of the pie chart, and set LabelField to PropertyName and ValueField to Count.

1 reply

Rocko
Rocko19-Tanzanite
19-Tanzanite
April 10, 2024

You will have to bind ValueField and LabelField with values from your result infotable, so they would be either StepStatus or Count_StepStatus, not "Propertyname" as in the screenshot.

Also the service Output ("result") would have to be not only set to Infotable, but needs a datashape assigned.

A
Aditya170216-PearlAuthor
16-Pearl
April 10, 2024

Hi @Rocko ,

 

Actually I have service named GetPassFailCount with Inspection_PassFailCount-DS as the datashape which has field definiton (PropertyName & Count).

Hence in the previous screenshot the DataField was set to PropertyName.

 

Can you guide me in what way I can show the pass/fail count in pie chart. 

I have QueryDataEntries which has a column named StepStatus with Pass/Fail as its values.

 

Also the GetPassFailCount service counts the number of pass/fail values of QueryDataTableEntries Service.

 

 

Rocko
Rocko19-TanzaniteAnswer
19-Tanzanite
April 11, 2024

What your service returns (columns StepStatus  and COUNT_StepStatus) does not match the Datashape you defined as shape for the result infotable. Those need to match because in a mashup, you can only bind the fields defined in the Shape, not the ones that are actually returned by the service. In your case it might be the easiest after the aggregate to Run to RenameField service so the infotable columns match the ones from the datashape.

result.

Resources["InfoTableFunctions"].RenameField({t: result, from: "StepStatus", to: "PropertyName"});
Resources["InfoTableFunctions"].RenameField({t: result, from: "COUNT_StepStatus", to: "Count"});

 

In your mashup, bind "All Data" from the service to "Data" of the pie chart, and set LabelField to PropertyName and ValueField to Count.

    Terms & ConditionsCookie settingsAccessibility statement