Navigation in Pie chart

[yoganantha321]

I have a calculated dimension  as below:

=If($(vAllocation)>7 , 'Occupied',

  If($(vAllocation)<4 , 'Available',

  If($(vAllocation)>3 and $(vAllocation)<8 , 'Partial Occupied')))

and expression as:

=count(DISTINCT EmployeeID)

It is showing the chart as

on selecting the above chart it must navigate to another sheet.

How can I achieve it anybody help me.........

Regards

Yoganantha Prakash G P

[krishnacbe]

Hi,

Create the dimension in Script and create the chart.

Create a Field Event Trigger - On Select to navigate to other Sheet.

[Anonymous]

As  you have static number of values in pie chart How about creating transparent text boxes on the chart and pulling trigger in the textbox??

[yoganantha321]

Hi Krishnapriya,

I must strickly not to disturb the data model by adding extra field

[Nicole-Smith]

Put a transparent text object over the pie chart and set the action on it to activate the sheet you want.

I've attached an example file with this functionality.

[yoganantha321]

It is not static values.

[Anonymous]

Not static values, but there are fixed number of values which is 3. You can create empty text boxes and transperent and use them as triggers by placing them on the pie chart, each on one sector.

[yoganantha321]

No, It is not associating with the navigating sheet....... It must also associate with the navigating sheet.

[awhitfield]

To Confirm: you can't add an action directly to a chart. You will have to use a worked around

Andy

[Anonymous]

Dint understand you by "not associating with the navigating sheet.". But check if this is what you want.