Skip to main content
L
LY_1069107912-Amethyst
12-Amethyst
August 8, 2024
Question

How to Use Filter chart Based on the dropdown Values

  • August 8, 2024
  • 1 reply
  • 1017 views

Hi Everyone,

I have a requirement in which I ahve data like this 

LY_10691079_0-1723120162500.png

 

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

1 reply

S
Surya_Tiwari16-Pearl
16-Pearl
August 8, 2024

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

L
LY_1083895510-Marble
10-Marble
August 9, 2024

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

S
Surya_Tiwari16-Pearl
16-Pearl
August 16, 2024

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.

Terms & ConditionsCookie settingsAccessibility statement