How to filter a table by click on pie charts sections

How to filter a table by click on pie charts sections

  
 I have a pie chart shows the counts of two conditions (Prove or Closed), and I have a table displayed below, is there a way to filter the table by clicking on the sections of the pie chart?
Hi Dongyu,

In short, you have to make the chart clickable and refresh the content of the table via ajax:
  • In the PieChart properties, set Clickable = True
  • In the PieChart properties, under On Click, create a new screen action (e.g. OnClick). It will be invoked when the user clicks a section of the chart. Service Studio will also add the DataPoint_GetClicked action to the screen action, which lets you get information about the click event.
From here, you probably want to refresh the query bound to the table and ajax-refresh the table itself. See attached a working example.


Hi Paulo,

Thank you so much that your solution works perfectly.