topic How to Use Filter chart Based on the dropdown Values in ThingWorx Developers

How to Use Filter chart Based on the dropdown Values

LY_10691079 — Thu, 08 Aug 2024 12:33:23 GMT

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

Re: How to Use Filter chart Based on the dropdown Values

Surya_Tiwari — Thu, 08 Aug 2024 16:49:10 GMT

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

Re: How to Use Filter chart Based on the dropdown Values

LY_10838955 — Fri, 09 Aug 2024 07:45:27 GMT

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

Re: How to Use Filter chart Based on the dropdown Values

Surya_Tiwari — Fri, 16 Aug 2024 11:31:16 GMT

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.