cancel
Showing results for 
Search instead for 
Did you mean: 

Listbox or filters

former_member211527
Participant
0 Kudos

Hi friends,

I am very new to xcelsius so im lagging in some behind to display data dynamically

i am having 4 dimension + 1 key figure out of 4 dimensions i.e(region,hub,circle,technology)  3 dimensions(region,hub,circle) i have taken it as  drill down in the  exel  format  i.e.,(region--->Hub-->circle)  i have shown region in pie chart if i clik particular region particular hub level display in column chart same way when i click on hub particular circle will dispaly in column chart it is done properly and the data shown in the dashboard. now the 4 th dimension the tehnology i want to show it in list box/filters or any component i want to show that when i clik on the technology the corresponding data had to change

let me know if im wrong any correct it becoz im new to this so tht..

can you tell me how to i filter the technology field in that.. i have strucked here..

Regards,

Ravi.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Ravi,

Can u pls clear my doubt,u want the data for ,region ,hub and circle to change when u click on technology on the list box... or wen u click a  circle u want corresponding technologies under that particular circle to be shown in a list box....

Thanks,

Arathy

former_member211527
Participant
0 Kudos

Hi Arathy,

Absolutely, correct when i click on technology in list box the data should be change in region,hub & circle.

i have achived in when i click on region for particular (eg south region south data should be display in hub. same way...

when i click on hub then corresponding data should be display in circle level...

regards,

ravi

former_member184839
Active Contributor
0 Kudos

Hi Ravi,

Sorry for the delayed Reply.

In the List box fetch the "source", from the query output, which is same as the the source of your "source" to the region (pie chart).

Mark the destination of this list box , to the destination of the pie chart you have used.

Don't give the Default selection to the list box. Follow the same procedure as you had done for the (region -> hub -> circle ). But make sure the destinations are the same.

That can work.

I haven't tried it out. Please do inform if it works.

Thanks,

Sara

Former Member
0 Kudos

Hi Ravi,

Change the source of pie chart based on the selection of Technology in the list box.

then you have already achieved the further drill from region to hub and hub to circle.

So based on the selection in technology the source data for pie chart should change and this data should flow across all the charts as per the drill.

Regards,

Madanamohan P

former_member211527
Participant
0 Kudos

Hi Sara,

Still i am not getting the changes yar..

if you dont mind can you send me your email address.. i can share you the excel source to you it will be more convienent to me to discuss with you.

Regards,

Ravi

former_member184839
Active Contributor
0 Kudos

Hi Ravi,

The components you've mentioned (pie chart & column chart) both have drill down option available in them. the circle thing which is the ellipse component doesn't have the drill down. Instead you can make use of bar chart or something like that, which has the drill down in it.

after you link the drill downs properly , n bind the destination (which are empty cells),

Link these empty cells to scorecard or list view. You will see the result .

Thanks,

Sara

former_member211527
Participant
0 Kudos

Hi Sara,

thank you ur inputs. but  my aim is  different

i will tell u more clearly i have taken sumif formula to display data for pie chart basis on that

column chart will display for the hub same liek that i am showing circle also in  columan chart

tht ends shwing in the dashbaord. now im having technology field  i was taken in ist box so that it should change dynamically

plz find the screen shot it will understand u bit clear..

Regards,

Ravi

former_member184839
Active Contributor
0 Kudos

Hi Ravi,

Can you be little more clear. Are you not getting the corresponding data of the Assam, Calcutta, north east, west Bengal in the list box ?

Thanks ,

Sara

former_member211527
Participant
0 Kudos

Hi Sara,

Thanyou for immediate reply...

see i have for particular region i have filtered the data  in excel   i.e for south soyth relaeted hub data will diasplay and when particular hub will select the it corresponding data will be display in the circle level

in list box i want to select particular technology type aso that data should be change randomly..

im simply attaching teh excel screen shot u may get idea...

regards

ravi