Custom event when clicking on bar in barchart

[#1]

Hi,

I cant get my head around how to change what happens if I click on a selected bar in a barchart. By default it filters the chart on the selected chategory.

I want to be able to change this behaviour to whatever I want (is it possible?).

For example, if I have a bar chart with sum of sales for 3 different products. If I click on bar for product 1, I want it to open a tab with details on that specific product (SH02).

Any ideas?

[Gysbert_Wassenaar · Accepted solution]

By clicking on the bar for product 1 you are selecting product 1. You could use the OnSelect field trigger for product to activate another sheet, SH02. Since you already selected product 1 the details chart on SH02 should already be filtered to show only details for product 1. So all you need is to add an action of type Layout - Activate Sheet and enter SH02 as the sheet ID.

[martin59]

Hi,

You have to create a trigger on field selection.

To do this :

• go to "Settings / Document Properties / Triggers"
• Select your field "Product"
• Add an action "On Select"
• "Layout / Activate Sheet" and write you SheetID

Hope that helps you

Martin Favier

[MayilVahanan]

HI

PFA

[#5]

Thanks!

[martin59]

It's a pleasure