I have created one pie chart using Xclsius2008, in the chart we have Country Names (India, China, England, USA ) and Headcount (1000,1500,500, .).
So actually there is lot of country names in the chart, we have nearly 70 country names. So I need any selection or filter to select the required country name in the dashboard. So I have created combo box and its working fine. So problem is, user need multiple selection or All selection for countries.
How to create All and Multiple selection for Combo box or is there any other filter option here?
We are using Xcelsius 2008, we are using Live Office connection, data source is BOXIR3 WEBI reports
Your problem with a pie chart is that it’s based on proportion (of the pie). If you only select a certain number of countries to display, your proportiions will be incorrect.
But list builder is your only option (I think) for allowing the user to choose how many elements to display.
I’m not getting correct results if i select the single country from combo box also. The country name is showing correctly but related Headcount was wrong. For every country the pie chart was showing first country headcount only.
Please check my combo box and pie chart properties.
My excel have two columns “Country Names” and “Headcount”
Country name start from B6 to B75 and Headcount from C6 to C75
properties
Combo Box: “General” tab
Labels -> selected all country names (B6:B75)
Data Insertion -> Insert Type= Label, Destination-> A1
I suspect you don’t have a distinct list of countries. So when you select - say - India, you’re only getting the first row where there’s a count against India, since xclesius doesn’t kno wthere’s another row further down.
You need to sum your values against a distinct list of countries before you start charting against them. This is best done at dabatase level before it gets into xcelsius, but you could probably do it with dsum or similar within xcelsius itself.
But it’s still going to look disproportionate in a pie. If you have thirty countries and select only two to display, your pie proprtion will be country 1/(country 1 + country 2) and not country 1/(all countries).
I have created Pie chart and Comb box with above properties(Mention above communication), and if select India then it is showing fine. if i select England then country name is comming correct but data was showing india headcount, same for USA also.
Many Thanks for your example, its very useful me to correct my existing dashboard chart properties.
Actually my dashboard has lot of other charts, labels and buttons. So, its very difficult to add List Builder for only pie chart, thats way I have created Combo box.
We can use any All function in the combo box or is it possible to hide List Builder after selecting the countries or any other option to select multiple countries?
As far as I know, list builder is the only component that allows you to select multiple options. If you have only a small fixed number of countries, there’s a workaround where you could use a toggle button for each - I have a graph with six separate things to display. I have a button for each which then adds that series to the graph. So the user can select any/all of the series at once and the graph scales change appropriately. To do this have your data in one block and use the toggle button to put a 1 or 0 in a cell. Elsewjere use an IF statement to populate a range based on there being a 1 in that cell. Bind the series to that range. So when the button is pressed, the series displays on the graph. Repeat for each series.
You can hide the list builder using the attributes of the component.
Yes, exactly Im looking for this logic.
Here they have used "Multi select combo box component for multiple selections in the demo. But they have not mentioned how to create “Multi select combo box”. i have not seen "Multi select combo box component in the Xcelsius2008.
Please let me know if you have any idea on “Multi select combo box” components creation.
Thanks.
Yes, exactly Im looking for this logic.
Here they have used "Multi select combo box component for multiple selections in the demo. But they have not mentioned how to create “Multi select combo box”. i have not seen "Multi select combo box component in the Xcelsius2008.
Please let me know if you have any idea on “Multi select combo box” components creation.
Thanks.
[/quote]
It’s not part of xcelsius. You have to pay for it on the site that Aeron is promoting.
Use your list builder to get your countries. Now you should have a subset of data just for the countries you want. If you roriginal country list was a distinct list as you said, the totals you have now will be per country. Hide your list builder component (maybe via a button that says “next” or “go” or whatever) and use this subset of data to build your charts.
(BOB member since 2010-07-08)
(BOB member since 2005-03-01)
(BOB member since 2005-03-01)
(BOB member since 2011-07-09)