am new to the xcelsius and just have a requirement.
I had a pie chart with 3 values say, A,B,C. When the user clicks on A, the other pie chart should display details like Aa1,Aa2,Aa3 with some values. and similarly for other values.
I can doing it by having multiple charts say one chart for displaying Aa1…Aa3 values, other for displaying Bb1,Bb2,Bb3 and other for displaying Cc1,Cc2,Cc3.(which is not feasible and not sure if this is the only way to do it)
Is there any way where i can doing it just by having 2 charts, one for displaying A or B or C values and other chart where it displays the values(what the user has clicked on)…
Yes. Use a separate range of cells with calculations which pick up the user selection (eg: if a1=‘A’ then c3, if A1=‘B’ etc). Then build your pie over this range.
I am going to provide one other alternative. While the first one posted would work fine, my personal preference is to avoid formulas wherever possible. The reason for this is purely performance. In most cases a purely component approach will perform better than formulas. Now granted this particular sample is pretty simple and straight forward but I’m guessing it will become a building block for building larger dashboards.
Out of curiosity, do you have any evidence to back this up? I try to do most of my processing at the database level, but I do use a lot of IF statements in my dashboards. Never thought about using filtered rows. Unfortunately I can’t download your sample as I’m not running SP5, but I might well have a play with that idea…
I’m not sure that I have any concrete evidence, just experience with developing large, complex dashboards. If developing simple dashboards (which is recommended) it is no problem leveraging the IF statements. In developing complex dashboards to meet some of our business requirements we have found reducing the number of formulas used and instead leveraging Filtered Rows results in a noticable difference in initialization time. May not be right for every instance but its a good tool to have in your toolbox.
Thanks for that. My dashboards are kind of mid-complexity… Like I said, I try to make the databases work for me as much as possible, but filtered rows might be a useful addition.
I was able to use the filtered rows to implement this. But i want the charts to be displayed in the same position.(e.g. if the user click on the summary chart, i want the detail chart to be shown in the same position as of summary, so that the user doesn’t feel that there are two different charts). I overlapped the two charts, but when i clicked on Summary chart, the detail chart is still hidden under summary chart.
Is there any way, where i can overlay them and achieve the functionality as desired.
[quote:0c260af064=“sree.kat”]Do you have any xlf file which show case the solution.
Vijay
[/quote]
Not for filtered rows, no. It’s not something I’ve tried. And I don’t have any cut-down drill examples right now - they’re all working dashboards and so I’m unable to share them.
I’ll probably put a drill one together at some point as I like to have simple examples to hand for when I forget how to do something…
(BOB member since 2005-03-01)