How to filter a table by click on pie charts sections

Dongyu Zhai

Question

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?

09 Sep 2015

Paulo Ramos

Staff

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.

ChartFilter.oml

09 Sep 2015

1 reply

22 Aug 2018

Show thread

Hide thread

Retha Bresler

Paulo Ramos wrote:

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.

Hello Paulo

I am having a similar problem Dongyu had. My problem is the same as Dongyu only that I have two pie charts that need to filter the same table, basically just adding an extra pie chart to the solution above. I am having trouble making the second pie chart also to filter the table.

Please help, thank you

22 Aug 2018

Dongyu Zhai

Hi Paulo,

Thank you so much that your solution works perfectly.

09 Sep 2015

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.

See the full guidelines