on 07-26-2012 7:55 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.