Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.
Hi,
You have to create a trigger on field selection.
To do this :
Hope that helps you
Martin Favier
HI
PFA
Thanks!
It's a pleasure