How to Use Filter chart Based on the dropdown Values

[LY_10691079]

Hi Everyone,

I have a requirement in which I ahve data like this 

Now i want to sort data Based on Approved state , Sports Category 
Mainly Approved State and then want to show the data on line or bar chart

so Basically requirement is in the drop down all the approved state will be there and when I select one of the approved state the data will populate in the Bar/ Line chart

so how can I implement this pls share your solution 

Thanks
Lav

[Surya_Tiwari]

Hi @LY_10691079  Can you look at the help center link below and let me know your feedback?

https://support.ptc.com/help/thingworx/platform/r9.5/en/index.html#page/ThingWorx/Help/Mashup_Builder/Widgets/ChipBasedDataFilterWidgetThemable.html

[LY_10838955]

Hi @Surya_Tiwari ,

I looked into this article but seems it is having a query as an input parameter but in my case I have an SQL query which is fetching data from DB so I am not sure how can I use this query as an input parameter to my SQL query so if you can guide here then it will be helpful and also like after querying this data how can I pass this to line/bar chart please share the solution if possible

Thanks in Advance
Lav

[Surya_Tiwari]

Hi @LY_10838955 

Can you share the entity here or is it better for you to create an SF case with the PTC support team, we will look it over.