Salesforce IdeaExchange
- then -
Force.com Platform Comments
| Force.com Platform Ideas
|
Reports and Dashboards Comments
| Reports and Dashboards Ideas
Pie Charts with Percentage Values Displayed
It would be nice to have the option of displaying the value of each slice of a pie chart as the percentage value represented by that slice. This could either be in lieu of the raw data that is currently displayed outside the pie as shown above or with the percentage values displayed after the description in the legend.
|
Kissa 08/23/07 |
I really like this idea |
|
TomaszOczapowski 08/29/07 |
I recommend to combine both, the value and percentage. Example 15 (47%). |
|
Heros 09/21/07 |
Similar Idea: http://ideas.salesforce.com/article/show/22721 |
|
chris925 09/24/07 |
Merged Idea
originally posted 10/07/06
%'s on pie charts / percent of total reporting
I'd like to be able to display pie chart values as %'s of the whole, instead of the raw number of records.
See my attached picture; instead of 15, 1 and 3 (the number of records), I'd like to be able to display those numbers as 78.9%, 5.3%, and 15.8% respectively. Similarly, I'd like to be able to report on "% of overall total" in reports in general, not just for pie charts. |
|
paulnakada 09/24/07 |
Merged Comment
originally posted 10/09/06
this could also be addressed by adding a "percent of total" summary to reports. both are very useful.
|
|
chris925 09/24/07 |
Merged Comment
originally posted 10/09/06
Paul, using a Custom Summary formula? It's been a while since I've tried that for this purpose, but it seems like either it didn't work as hoped or didn't play when sent to Excel (via the add-in etc.). It would be great if it were a feature of the pie chart feature, though yeah % of total in general would be good too.
|
|
AmandaFoord 09/24/07 |
Merged Comment
originally posted 10/10/06
Percent would be brilliant. Also it would be good if you could select what goes into the OTHER catgory on a pie chart when it is unable to display all the categories.
|
|
chris925 09/24/07 |
Merged Comment
originally posted 10/10/06
Good call Amanda! At least the ability to set the Other % (Other = 10% etc).
|
|
Odin 09/24/07 |
Merged Comment
originally posted 10/18/06
I agree wholeheartedly about the "other" category. I'd like to see it done away with completely, or be based on the "maximum values" field that you fill out. In other words, if the maximum values is set to 10, the top 10 show up and the rest are all lumped into "other". The current "4% rule" causes great confusion.
|
|
mike4SE 09/24/07 |
Merged Comment
originally posted 11/21/06
[The SFDC guys said we should post comments here when we can help, so here's another! ]
Our Sales Executive dashboards provide this kind of percentage based piechart labeling (in addition to a lot of other cool visualizations like a pareto chart showing cumulative percentages). You can take a closer look at us on AppExchange or view our 15 minute webcast. Thanks, Mike MacDonald Visual Mining Inc. |
|
PerGeert 09/24/07 |
Merged Comment
originally posted 02/04/07
In continuation of discussion of the "Other" category: I report on a field which has 4 values: A, B, C, D. Since there are less than 4% of As, the labels on the pie chart are B, C, D, Other. A little stupid.
|
|
MsOz 09/24/07 |
Merged Comment
originally posted 02/07/07
% yes please, my management ask for this too.... currently I have to export to excel and have created a macro which graphs using percentages......
I also agree the OTHER is a total annoyance. One other thing which is greatly annoying is we use pies to compare regions, the largest piece of pie is always red, you cannot assign red to always be used for a particular category, so if in the next region the largest category is different it too is red. I've tried using custom formulas for % and cant get anywhere, any ideas? |
|
ggsell 09/24/07 |
Merged Comment
originally posted 03/07/07
You can try using a Custom Summary Field depending on which fields you are reporting on. In this case, you would need an additional field to designate Email then do a Forumla saying =(#email/#cases)*100 to show the percentage. This is a work around that has worked for me.
|
|
Dreamteam 09/24/07 |
Merged Comment
originally posted 03/14/07
Chris, our Carousel product does this now. Please have a look at www.dreamfactory.com/carousel.
Thanks. - Travis |
|
KerryT 09/24/07 |
Merged Comment
originally posted 09/18/07
I get asked why this is not possible on a weekly basis.
|
|
DarrenC 09/24/07 |
Wow, this one has really bubbled up. If you're looking for more than just % on pie charts, you might be interested in taking a look at LucidEra. Our on-demand business intelligence platform is designed from the ground up for ad hoc queries and slice and dice analysis. http://www.lucidera.com/ |
|
richard321 Apr 25 |
This seems like a really basic necessity for reporting. Every time I should a pie chart I get the same comments and I have to say Salesforce can't display percentages and I feel like a goon. |
|
richard321 Apr 25 |
This seems like a really basic necessity for reporting. Every time I show a pie chart I get the same comments and I have to say Salesforce can't display percentages and I feel like a goon. |
|
pnash Aug 6 |
This would be extremely helpful to me. I would like to know when this might be implemented. |
|
mscotton Aug 12 |
One possibility for a workaround is to try using a Custom Formula Field that references the google chart api. I haven't used it to display the percentage, just the raw amounts, but you can pass it whatever text you want to display. For example, let's say that on your object you have 2 custom currency fields: Amount1__c and Amount2__c. The formula to display these values in a pie chart is: IMAGE("http://chart.apis.google.com/chart?cht=p3&chd=t:" & Text( Amount1__c ) & "," & Text( Amount2__c ) & "&chs=300x100&chl= First Label|Second Label", "chart text") |
track comments for this idea
Please log in to post a comment
last 100 promotions:
- etf
- michaellatideas
- johnwa
- nlichte
- adamcoyle
- bwtech
- jormy
- sandrad
- artursoler
- michaus
- alexcmx
- nachoheitz
- josegarcia
- elrane
- cecy
- bettyrocha
- santiagotrevino
- dapellegrini
- alexy
- Jbrixel
- ramm19
- fishdaddy
- larryssuggestions
- tom4
- allmans1
- juliarm
- gqaz126
- datarzan
- bluekeystone
- pnash
- Letty
- wellingtonbelle
- conlho
- Smarks
- rce
- nerea
- angie
- Candleroses
- bhfs
- markus_wirkner
- ukspike
- nimmy
- patrick_karkabi
- pedro_angulo
- mau
- merial
- MKPartners.com
- dunnos
- moni
- BryanMQuinn
- annemoore
- belcherlc
- carolee.bender@borland.com
- dfg713
- SueHall
- abarr
- Lacertosus
- pj100
- petesav
- 02/23/2007_2:25
- bbseven
- richard321
- jasonlong
- gemma
- Westwood
- jason_lowry
- JBA
- laguz
- greg101
- faroadmin
- KimberlyD
- zanoonhi@hikma.com
- nbanas
- rkcrmdirector
- jdev
- smithle
- joyd
- cuatthetop
- Jesterale
- bdaadmin03252008
- chadr
- JMoncrieff
- guillermosrs
- ankit_gandhi
- jjuez
- tz
- chopair
- kwright10192007
- mh6788
- tdoonan
- aschutzengel09272007
- megmdks
- matthewlamb
- ssm2
- Kbenavidez
- sonnynpower
- TheBoot
- RentokilAlec
- meh
- rwerzyn
POST IDEA