pie chart

[#1]

Hi,

I have Zone field with fieldvalues- Zone1, Zone2, Zone3

and State field with fieldvalues- AP, Gujarat, Punjab, UP, Tamil Nadu , Kerala

Now, I have created a pie charts showing  count of managers with a dimension  as Activity

The requirement is when I select 1 zone , I am supposed to create 2 pie charts for the associated states and when I select other zone the same charts will be showing the associated data.

eg if I select Zone1 then the 2 pie charts should show AP  and Gujarat data whereas when I select Zone2 same charts should show Punjab and UP data.

This I am trying to implement as it will reduce the number of pie charts required.

Thanks in advance!!

[sasikanth]

Hi

try to enable the state dims based on conditons

EX;

add all the dims (states)

create condition and check ENABLE CONDITIONAL

like

for AP and GUJARATH

getFieldSelections(ZONE)='Zone1'

similar for all zones

Hope it helps

Thanks

Sasi

[jyothish8807]

Hi Rajeshree,

Can you share your sample data sourse?You can acheive this by setting up an condition like

if(getFieldSelections(ZONE)='Zone1',count({<state={'AP','Gujrat'}>}Manager),if(getFieldSelections(ZONE)='Zone2',count({<state={'AP','Gujrat'}>}Manager) ........

Something like this.

Hope it works

Regards

KC

[jyothish8807]

change the state in else if condition.

Regards

KC