How to pass filtering data to the Bar chart/ Pie chart graph

[LY_10691079]

Hi Everyone,

I have a requirement like suppose I have a dropdown of different states now If I select a particular state it show data associated with that state in Grid data format and also their distinct count on bar chart.

now my requirement is when user filter data based on different column name then the data in pie chart should change how can I configure this thing

What I have done is through SQL queries I am taking distinct count of each column and showing that on bar chart. My requirement is now if user click on filter of the data for that used (data filter widget for grid data) then that should also trigger the data of bar chart and shows the exact count based on filtered data.

Thanks,

Lav

[olivierlp]

Hi @LY_10691079 

May I suggest adding a few details about your questions? It may help others to engage. We are suggesting a few "question best practices" here.

[pshashipreetham · Accepted solution]

Hi @LY_10691079 ,

1. Create a Service (Second service) for the Logic.
2. In the Second Service, add two inputs, one to take the input from the Service, which gives all the data.
3. The other input takes filter inputs or filtered data
4. If there is no filtration, then show all data
5. If there is any filter, show the filtered data on the Widget.

Thanks,