Pie chart trigger

[Anonymous]

Guys,

I have a pie chart showing three type of employee's count (Available, Occupied and Partially Occupied). If I select only available employees it should be navigated to another sheet and to enable the available filter option in that sheet. Similarly for occupied and Partially occupied employees. Plz let me know if it is possible? if it is how to do? Plz help me guys....

[adamdavi3s]

Hi Siva,

This is certainly possible, you could do it as an event trigger on the field employee type (under document properties)

Depends if you want to trigger it just for that specific chart or not?

[adamdavi3s]

Here is an example, note that the same happens if you select the chart or the listbox

Edit sorry just updated the example to only trigger on available

[MK9885]

Yes it is doable.

If your (Available, Occupied and Partially Occupied) are measure then probably store them as a variable and use this IF condition in layout for the sheets or create a trigger as mentioned by Adam.

If they are dimensions, same can be done.

[Anonymous]

Thank you guys, But in filter I have calculated dimension expression How can I achieve it?

[adamdavi3s]

can you give us a sample to work with?

[Anonymous]

Adam, I'm using this expression as calculated dimension in filter,

=IF( MonthlyWorkHour>7, 'Occupied',  IF(  MonthlyWorkHour>3 and MonthlyWorkHour<8, 'Partially Occupied',  IF( MonthlyWorkHour<4,  'Available' )))

[adamdavi3s]

Ok check this out, sorry used my own field names.

There is now a variable and a trigger on this variable

[MK9885]

Can post a sample app?

[Anonymous]

when I clicked on available (red region) in the chart, it should be navigated to another sheet enabling available option having the filter as shown below,

Plz help me guys, I'm having calculated dimensions in this filter, so I'm confused...