Skip to main content
L
LY_1069107912-Amethyst
12-Amethyst
May 7, 2024
Solved

How to pass runtime data into bar chart

  • May 7, 2024
  • 3 replies
  • 996 views

Hi Everyone,

 

I have a Grid widget which displays data based on selected dropdown, also a data filter widget through which I am filtering grid data so now my requirement is I want to display distinct count of each column in Bar chart widget and  once the data is changed it through data filter widget (for the same dropdown)   bar chart data should also change like whatever data present in grid that data's distinct count should available in bar chart at runtime.

 

like in runtime if data change according to the filter (Through data filter widget) that should also change the bar chart count that's it.

can we achieve this functionality in Thing Worx 9.3.1 version.

 

if yes pls guide 

 

I am able to get distinct count in bar chart but next is how it should change while filtering which is in runtime actually, I am not sure 

 

Thanks,

Lav

Best answer by PEHOWE

@LY_10691079 
I am going to make some assumptions. You are using the dropdown to make a selection. This selection is being sent to a Service as an input parameter.

The service then builds the InfoTable. 

I believe your confusion is how do I include the ChipDataFilter Widget in the processing.

The service which generates the InfoTable needs to have an additional parameter of type "Query"

At the end of the steps which you already have in place you need to add a call to update the InfoTable before it is returned.

let params = {
t: result,
query: FilterQuery
};

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

When the service is run the initial time, The fall to the Query function will make no changes to the result.
Now the binding: 

From CreateGrid service all data goes to the ChipDataFilter, The Query is bound to The CreateGrid service and the Grid. 
The Query Changed event is bound to the CreateGrid service, this causes an update on every change.

 

If you have questions please let me know

 

Pehowe
 

3 replies

V
19-Tanzanite
Velkumar19-Tanzanite
19-Tanzanite
May 9, 2024

Hi @LY_10691079 

 

You can execute bar chart service once grid service completed event. It will be easier to suggest or guide if you post some screenshot of your mashup bindings

 

/VR

P
PEHOWE17-PeridotAnswer
17-Peridot
May 9, 2024

@LY_10691079 
I am going to make some assumptions. You are using the dropdown to make a selection. This selection is being sent to a Service as an input parameter.

The service then builds the InfoTable. 

I believe your confusion is how do I include the ChipDataFilter Widget in the processing.

The service which generates the InfoTable needs to have an additional parameter of type "Query"

At the end of the steps which you already have in place you need to add a call to update the InfoTable before it is returned.

let params = {
t: result,
query: FilterQuery
};

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

When the service is run the initial time, The fall to the Query function will make no changes to the result.
Now the binding: 

From CreateGrid service all data goes to the ChipDataFilter, The Query is bound to The CreateGrid service and the Grid. 
The Query Changed event is bound to the CreateGrid service, this causes an update on every change.

 

If you have questions please let me know

 

Pehowe
 

P
PEHOWE17-Peridot
17-Peridot
December 11, 2024

Hello @LY_10691079 ,

 

It appears that  your question.  Had a reply which may have answered your questions. For the benefit of other Community Members who may have the same question, it would be great if you could designate it as the Accepted Solution.

In the event that this response did not answer your question, please post your current status so that we can continue to support.

Thanks for using the PTC Community!

Regards,

pehowe

Terms & ConditionsCookie settingsAccessibility statement