Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Custom event when clicking on bar in barchart

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?

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand

View solution in original post

5 Replies
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
martin59
Specialist II
Specialist II

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

Thanks!

martin59
Specialist II
Specialist II

It's a pleasure