Author Topic: [solved] Using multiple facts in pie chart to total 100%  (Read 16082 times)

Offline mikegreen

  • Community Leader
  • *****
  • Join Date: Nov 2005
  • Posts: 141
  • Forum Citizenship: +3/-0
Hello folks,

  I think I must be missing something obvious, but we'll see....

  My goal is to have a pie chart that shows the breakout (percentage) of items by type, and each item type is a separate fact item in my query subject.
  For example, if the query subject is like this (dont comment on the poor design, the data dictates it this way in our warehouse):
Store1, Item1_QTY, Item2_QTY, Item3_QTY
And the data was like this:
CityStore, 20, 50, 30

I would like a pie chart for CityStore showing 20% blue, 50% red, and 30% green (or whatever colors the palette picks).. but want them all in the same Series.

If I drag each data item (Item1_QTY, 2, 3, etc) over to the Series (#3) in the chart design in ReportStudio, I get 3 pie charts. 

Is there a way to use these separate data items as one, making up 100% of a single pie chart?  This seems quite simple, but I can't figure out how to do it!

Cheers,

Mike
« Last Edit: 15 Nov 2005 02:29:21 pm by mikegreen »

Offline mikegreen

  • Community Leader
  • *****
  • Join Date: Nov 2005
  • Posts: 141
  • Forum Citizenship: +3/-0
Found it myself, yay!
« Reply #1 on: 14 Nov 2005 06:19:15 pm »
Ok, I'll answer my own post :-)

In the Chart Properties (Pie Chart), the "Plot Measures As" defaults to "Categories" which results in a pie chart created for each item in (#1 area) "Measures". 
Changing the "Plot Measures As" value to "Series" instead of "Categories" did the trick.  It now uses the fact items in the "Measures" as the graph source, and the Series/Categories axes to determine more pies made.

Thanks, self! Hope that helps someone down the road...

-Mike

Offline naveen kalaimani

  • Full Member
  • ***
  • Join Date: May 2008
  • Posts: 8
  • Forum Citizenship: +0/-0
Re: [solved] Using multiple facts in pie chart to total 100%
« Reply #2 on: 31 May 2008 08:47:46 am »
Hi Mike...

This topic of yours has really helped me to solve a couple of similar problems i have been facing....

Thanks..  ;)

Naveen

Offline afharidy

  • Associate
  • **
  • Join Date: Sep 2008
  • Posts: 3
  • Forum Citizenship: +0/-0
Re: Found it myself, yay!
« Reply #3 on: 17 Aug 2010 10:50:38 am »
Where is such property ("Plot Measures As"), I tried to find it.
Should I update the chart somehow so I can find it?


Please HELP , I have the same problem

Offline bhaswanth87

  • Associate
  • **
  • Join Date: Oct 2011
  • Posts: 3
  • Forum Citizenship: +0/-0
Re: [solved] Using multiple facts in pie chart to total 100%
« Reply #4 on: 12 Oct 2011 11:48:06 am »
That option is available only in ReportNet
We dont have that option in Report Studio.
Solution: Create a new data item(say 'total') by summing all measures(M1,M2...)
Place 'Total' in 'Default Measure' box and (M1,M2...) in 'Series(Pie Slices)'

 


       
Twittear