Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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
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
change the state in else if condition.
Regards
KC