chart links to another page

[aaronnayan]

Hi Guys

I have a pie chart, with 9 expressions (segments)

I want it so, when the user clicks on 1 segment of the chart it will take him to another page.

I know the use of buttons but i want it to activate a sheet when you select the chart segment.

Many thanks guys

[#2]

It is not possible to jump from one sheet to another without the use of buttons in your condition.

The workaround would be to create buttons equal to the size of your bars and set the action accordingly.

Cheers,

Rohan

[Sergey_Shuklin · Accepted solution]

Hi, Aaron!

It is possible.

For instance you have a data:

Load * Inline

[task,val

A,10

B,20

C,30];

Load it. Create a circle chart with dimension "task" and expression "=sum(val)". You'll get your navigator 😃

After that go to the trigger menu (Ctrl+Alt+D -> Triggers), find our field "task" in Field Event Triggers and press Edit Action OnSelect. Choose Layout -> Activate Sheet and where is the sheet should be inputed place an expression:

=pick(match(GetFieldSelections(task),'A','B','C'),'SH02','SH03','SH04')

or you can use a simple function IF to determine sheet name depend of GetFiledSelections(task) funcion.

In my case sheets have a name SH01, SH02 you may have a different ones.

That's all! Now, if you done it right you'll be able to move among sheets by clickin on the pie pieces.

Hope you find it usefull!

P.S.: I've added an example and correct some little mistakes in the text.

[aaronnayan]

Hi Sergey

Thankyou it is possible!. How can this be done if you do not have a dimension in the chart?

[Sergey_Shuklin]

Hi, Aaron!

I've tried to make it w/o a dimension and for now I have no result, because nothing is happenin' when user is clickin on expressions (no selections are returned). Maybe later, when my experience will grow I'll find the answer, but for now I can offer only one decision.

[Frank_Hartmann]

this might be helpful:

Re: Pie Chart