representing pies as selected countries

Question

representing pies as selected countries

prepaess

Mr or Mrs. 500

Points: 531
More actions
June 4, 2014 at 12:24 pm

#292026

hi all did any one know how can i make pies by select means for example i have two country and i will calculate number of women and man so
if user select one country it will appear one pie , and when he select both of them he will have two pies
thanks a lot for any answer

Viewing 15 posts - 1 through 15 (of 16 total)

You must be logged in to reply to this topic. Login to reply

Sean Lange SSC Guru Points: 286590 More actions · Answer 1

prepaess (6/4/2014)
hi all did any one know how can i make pies by select means for example i have two country and i will calculate number of women and man so
if user select one country it will appear one pie , and when he select both of them he will have two pies
thanks a lot for any answer

Did you try BOL or google? I think you are asking how to create a pie chart in SSRS?

http://msdn.microsoft.com/en-us/library/dd220426.aspx

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

prepaess Mr or Mrs. 500 Points: 531 More actions · Answer 2

no not how draw a pie but a code that alloaws me to draw more than one pie

so that i will have a list of country in a combobox if i select france for example the pie of france will appear

if i select france and america

two pies will appear one for france the other for america

is it clear please ?

thanks a lot for any help

pietlinden SSC Guru Points: 63503 More actions · Answer 3

I think he's talking about something more like this, but this is PowerView in Excel 2013...

http://office.microsoft.com/en-us/excel-help/maps-in-power-view-HA103005792.aspx

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 4

Aside from the fact that a pie chart is a horrible visualization that is easily misinterpreted, you can solve your issue by creating a matrix with country in the columns. Put your pie chart in the cells and you will get a pie chart for each country (as each country gets its own column when rendering the report).

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

prepaess Mr or Mrs. 500 Points: 531 More actions · Answer 5

Koen Verbeeck (6/5/2014)
Aside from the fact that a pie chart is a horrible visualization that is easily misinterpreted, you can solve your issue by creating a matrix with country in the columns. Put your pie chart in the cells and you will get a pie chart for each country (as each country gets its own column when rendering the report).

i put the pie in the value cell ?

can you give me an example please

so as i understand i put just one pie in the matrix and the others will be created automatically ?

thanks a lot for any help

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 6

You can find an example here:

SSRS 2008 – Lattice Charts (Small Multiples)

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

prepaess Mr or Mrs. 500 Points: 531 More actions · Answer 7

Koen Verbeeck (6/5/2014)
You can find an example here:
SSRS 2008 – Lattice Charts (Small Multiples)

it is not clear , please is there any tutorial that show exactely the steps of doing that

thanks a lot for any answer

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 8

prepaess (6/6/2014)
Koen Verbeeck (6/5/2014)
You can find an example here:
SSRS 2008 – Lattice Charts (Small Multiples)
it is not clear , please is there any tutorial that show exactely the steps of doing that
thanks a lot for any answer

If you would have thoroughly read that article, you would have noticed there are two links to other articles who explain the same concept.

You could even download the sample report file to find out what he had exactly done to achieve that result.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

prepaess Mr or Mrs. 500 Points: 531 More actions · Answer 9

Koen Verbeeck (6/6/2014)
prepaess (6/6/2014)
Koen Verbeeck (6/5/2014)
You can find an example here:
SSRS 2008 – Lattice Charts (Small Multiples)
it is not clear , please is there any tutorial that show exactely the steps of doing that
thanks a lot for any answer
If you would have thoroughly read that article, you would have noticed there are two links to other articles who explain the same concept.
You could even download the sample report file to find out what he had exactly done to achieve that result.

in fact to download the sample it needs an authentification

prepaess Mr or Mrs. 500 Points: 531 More actions · Answer 10

ok i did not pay attention ,in fact i did the example he has done but me what i want that i have just one column for categore and one for country

so that i get this

graphic

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 11

What if you drop the pie chart on the rows, instead of the columns?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

prepaess Mr or Mrs. 500 Points: 531 More actions · Answer 12

there is just one cell for data what did you mean by draging it in row ?

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 13

prepaess (6/6/2014)
there is just one cell for data what did you mean by draging it in row ?

The category group (country in your case) should be on the rows, not on the columns.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

prepaess Mr or Mrs. 500 Points: 531 More actions · Answer 14

i solved the problem in fact i keep just one row country and then put the chart in data

but my problem is now in the legend it is not the same for all pies what should i do ?

thanks a lot for any help