CFCHART - Percentages not right

Report · Jan 21, 2012

I tried to set up a simple chart to display the results of a query, it works fine with labelformat="numbers", but if I change it to percent the results are odd, I get values above 100% on many of the pie slices. Anybody any idea?

Here's the code

<CFCHART

format="flash"

show3d="yes"

showlegend="yes"

chartheight="800"

chartwidth="900"

labelformat="percent"

showborder="true"

pieSliceStyle="sliced"

sortXAxis = "yes"

>

<cfchartseries

type="pie"

query="GetCountry"

valuecolumn="countrycounter" itemcolumn="countrylong" />

Thanks

Mark

Report · Jan 22, 2012

Can you provide a repro case that includes the data (which is kinda important to your question).

Just mock a query up with queryNew() / queryAddColumn() etc.

Where possible, if you have a problem you should try to give us a repro case that is completely self-contained, and stand-alone (without any inferences as to how external systems like DB data might affect what you're seeing). Obviously this is not always possible, but it definitely is in this case.

Cheers.

--

Adam

Report · Jan 22, 2012

The query is pretty basic

	<CFQUERY NAME="GetCountry" DATASOURCE="#datasource#">
	SELECT countrylong,countrycounter
	FROM countrylist
	WHERE countrycounter > 0

</CFQUERY>

Here is a CFDUMP of the data

query

RESULTSET

query
	COUNTRYCOUNTER	COUNTRYLONG
1	2	BELGIUM
2	13	ALGERIA
3	6	KUWAIT
4	10	OMAN
5	2	VENEZUELA, BOLIVARIAN REPUBLIC OF
6	28	PHILIPPINES
7	12	BRUNEI DARUSSALAM
8	2	CZECH REPUBLIC
9	4	GHANA
10	1	BANGLADESH
11	71	MALAYSIA
12	505	UNITED STATES
13	32	ITALY
14	1	LATVIA
15	2	PANAMA
16	2	NORWAY
17	5	AUSTRIA
18	8	ROMANIA
19	63	THAILAND
20	5	NETHERLANDS
21	27	MEXICO
22	12	UNITED ARAB EMIRATES
23	4	IRAQ
24	22	EGYPT
25	65	KOREA, REPUBLIC OF
26	114	VIET NAM
27	3	SWITZERLAND
28	11	SWEDEN
29	6	MOROCCO
30	27	UNITED KINGDOM
31	13	SPAIN
32	18	CHINA
33	5	CAMBODIA
34	66	INDONESIA
35	7	JORDAN
36	26	TURKEY
37	13	SINGAPORE
38	3	BAHRAIN
39	34	GERMANY
40	17	AUSTRALIA
41	407	INDIA
42	14	KAZAKHSTAN
43	33	SLOVAKIA
44	14	PAKISTAN
45	4	KENYA
46	8	UKRAINE
47	111	SAUDI ARABIA
48	26	TAIWAN
49	2	ISRAEL
50	29	BRAZIL
51	4	PERU
52	5	ARGENTINA
53	5	COSTA RICA
54	1	LAO PEOPLE'S DEMOCRATIC REPUBLIC
55	43	RUSSIAN FEDERATION
56	10	CANADA
57	6	SERBIA
58	5	PUERTO RICO
59	3	SLOVENIA
60	3	BELARUS
61	4	FINLAND
62	39	HONG KONG
63	1	GUAM
64	85	JAPAN
65	6	SOUTH AFRICA
66	1	ESTONIA
67	3	HUNGARY
68	6	GREECE
69	2	DENMARK
70	16	FRANCE
71	1	BULGARIA
72	2	GUADELOUPE
73	1	TURKMENISTAN
74	4	POLAND

CACHED

false

EXECUTIONTIME

2

SQL

SELECT countrylong,countrycounter FROM countrylist WHERE countrycounter > 0

Report · Jan 22, 2012

Can you go back to my earlier post and read it. You've not provided a repro case, you've just given me a dump of some data. What am I supposed to do with that?

A repro case is some code that can be run and deomnstrates the problem (and then it can be tweaked etc to work out what the problem is). SO go back and - please - do what I've asked you to do. This is all part of learning how to solve your own problems (which in the long run is gonna be more helpful to you than just asking questions).

Trust me.

--

Adam

Report · Jan 23, 2012

ACS LLC wrote:
I tried to set up a simple chart to display the results of a query, it works fine with labelformat="numbers", but if I change it to percent the results are odd, I get values above 100% on many of the pie slices. Anybody any idea?
Here's the code
<CFCHART
format="flash"
show3d="yes"
showlegend="yes"
chartheight="800"
chartwidth="900"
labelformat="percent"
showborder="true"
pieSliceStyle="sliced"
sortXAxis = "yes"
>
<cfchartseries
type="pie"
query="GetCountry"
valuecolumn="countrycounter" itemcolumn="countrylong" />

You are right. The chart attribute labelformat="percent" produces a pie chart with percentages that don't match. Indeed, many are several hundred percent! That could possibly be a bug.

To correct the problem, use the following chartseries attribute instead: datalabelstyle="pattern". That is

<CFCHART

format="flash"

show3d="yes"

showlegend="yes"

chartheight="800"

chartwidth="900"

showborder="true"

pieSliceStyle="sliced"

sortXAxis = "yes"

>

<cfchartseries

type="pie"

query="GetCountry"

datalabelstyle="pattern"

valuecolumn="countrycounter"

itemcolumn="countrylong" />

</cfchart>

However, be aware that it is inadvisable to represent more than, say, a dozen or so data values on a pie chart. It can then get a bit crowded, especially if you decide to slice the pie, as you have done. In any case, 74 data points is way too much data to represent on a pie chart.

Report · Jan 23, 2012

Thanks for the help, I could not find any info on datalabelstyle, and even after a search now that I have it I can't find anything

You are right, once I added this, its a little busy, trying to label every country

I think I might be best trying to label with a percentage and then mouse over for the country with percentage but I'm not sure if this can be done?

Right now when I mouse over the slice I get the country name with a total, but no percentage.

Is it possible to put the percentage and country etc into the mouse over label?

Then perhaps I can switch the regular label to just a percentage

Thanks!

Mark

Report · Jan 24, 2012

ACS LLC wrote:
Thanks for the help, I could not find any info on datalabelstyle, and even after a search now that I have it I can't find anything
You are right, once I added this, its a little busy, trying to label every country
I think I might be best trying to label with a percentage and then mouse over for the country with percentage but I'm not sure if this can be done?
Right now when I mouse over the slice I get the country name with a total, but no percentage.
Is it possible to put the percentage and country etc into the mouse over label?
Then perhaps I can switch the regular label to just a percentage

The functionality you seek could be in some curious attribute combination in there somewhere. However, we could also play dumb, and create just what we need manually, and then do a mouseover. I was thinking of something like this

select sum(countrycounter) as sumCounter

from GetCountry

</cfquery>

select countrycounter*100/#getSum.sumCounter# as countryCounter, countrylong

from GetCountry

</cfquery>

<CFCHART

format="flash"

show3d="yes"

showlegend="yes"

chartheight="800"

chartwidth="900"

showborder="true"

tipStyle = "mouseOver"

pieSliceStyle="sliced"

sortXAxis = "yes"

>

<cfchartseries

type="pie"

query="getCountryPercentage"

valuecolumn="countrycounter"

itemcolumn="countrylong" />

</cfchart>

Report · Jan 24, 2012

Very Creative

That's much easier to read now, the only thing I am missing is the totals, in the first attempt on the main labels that were visible without mouse over it had the count of the slice and also 'out of' ... am I pushing it now 😉

Thanks

Mark

Report · Jan 24, 2012

ACS LLC wrote:
Very Creative
That's much easier to read now, the only thing I am missing is the totals, in the first attempt on the main labels that were visible without mouse over it had the count of the slice and also 'out of' ... am I pushing it now 😉

That was the datalabelstyle="pattern" attribute of the chartseries. However, it puts the "out of..." on the chart itself, not on the mouseover. In any case, if we were to do that now, I would expect it to say "out of 100%"!

Report · Jan 24, 2012

it works fine with labelformat="numbers", but if I change it to percent the results are odd, I get values above 100% on many of the pie slices

"LabelFormat" does not perform calcuations. It just applies a simple mask to the axis values, controlling how they are displayed ie As a simple number (33), percentage (3300%), currency ($33.00) etecetera.

Adobe Community

CFCHART - Percentages not right