Pie chart selection in Setanalysis

[#1]

Hi Guys,

I know that when a setanalysis expression is given like this in a piechart

Count({<[Process version_VERSION]={'Version_1'},Department={'IT'}>} Distinct [Composite role/User_UNAME])

it is hardcoded but what I need is that these fields are selected when I select a part in a piechart.

Hope anyone can help! Any Ideas?

Thanks

Sravan

[#2]

Does this solve your problem? I added actions in Docproperties->Triggers->field event triggers:

Field: Risk level

Trigger: On select.

Regards,

Kiran.

[jonathandienst]

Sravan

Perhaps I've not understood your requirement, but do you mean that you want to view the count of whatever you've selected in the piechart? If that is the case, you just need to lose the part(s) of the set analysis that you are selecting.

Hope that helps

Jonathan

[#4]

Hi Jonathan,

But when I click on the No of users in the Piechart, I cannot get the selections like the Department and Version selected automatically. Without setanalysis pie chart does not run.

Kiran gave a route to work and it is what I need. Though kiran's work for whole Document. I need to make per Object to get it right!

Thanks for your help

Sravan

[#5]

This solves the problem of "having at Object Level". Please check the attachment. Sheet triggers for chart35. Macro called at document level On Field selection.

Regards,

Kiran.