LiveDocs Comments - coldfusion - 6 - CFML_Reference - Tags-pt112.htm

coldfusion/6/CFML_Reference/Tags-pt112.htm

James_Hull — 2005-09-28T09:18:23

How do you use URLENCODEDFORMAT with the $ITEMLABEL$ and $SERIESLABEL$ variables in the url attribute of CFCHART? I need to pass fairly complex text that includes ampersands and single quotes but I get "Variable $ITEMLABEL$ is undefined" if I use something like url="disp_drillspend2.cfm?item=#urlencodedformat($ITEMLABEL$)#&series=#urlencodedformat($SERIESLABEL$)#&value=$VALUE$&type=#url.type#" in the CFCHART tag.

coldfusion/6/CFML_Reference/Tags-pt112.htm

jrunrandy — 2005-06-28T12:10:15

You can add feature requests at http://www.macromedia.com/go/wish/

coldfusion/6/CFML_Reference/Tags-pt112.htm

cdary — 2005-06-01T09:33:04

Feature Request: Would be helpful if there was a "Round to Integers" attribute so that we wouldn't end up with odd decimals in the chart. I know zedfox was helpful enough to provide a workaround, but this should be something provided by the tag, in my opinion.

coldfusion/6/CFML_Reference/Tags-pt112.htm

ASandstrom — 2005-05-11T07:29:06

There is a tech note about cfchart not working when the server is started as a domain account at:
http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19605

coldfusion/6/CFML_Reference/Tags-pt112.htm

WolfShade_2k — 2005-04-18T08:31:19

Is there any control for thickness of horizontalbar chart bars? When I started with cfchart, the bars were WAY thick; I don't know what I've done, but now they are WAY THIN and not centering with the data name they are representing (ie, the ones on top are floating above the centerline of the x-axis, the ones on bottom are floating below.)

The client is asking for a lot of things that cfchart does not currently do (like hiding the numbers of the x-axis, etc.); are there any plans to include more control of cfchart in the future??

coldfusion/6/CFML_Reference/Tags-pt112.htm

zedfox — 2004-12-14T11:54:24

On charts, you may find your Y-axis values to be in decimals instead of whole integers. To have your Y-axis values in integers, find out the max. and min. value of the series you are plotting. Create as many gridlines as there are whole numbers from the range of series data.

e.g. if your values that you want to plot are 1.5,2.5 and 3.5,
your range is 1.5 to 3.5 is actually 2, but it would be best if you FLOOR 1.5 to 1 and CEILING 3.5 to 4. Your max and min are 4 and 1 respectively and your range is 3. Create a variable called #gridline# that is your-range + 1 = 4. Pass this variable to gridline attribute in . There goes your whole integer valued Y-axis now :)

Hope this helps. Thanks. Chirag Shukla.

Note: If you use MS Access, you may want to simulate FLOOR function using Round(yourvalue - 0.5) and simulate CEILING function using Round(yourvalue + 0.5).

Here is a code that you might find interesting:

No records found

select round(max(maxat*1.8+32+0.5)) as maxelement1, round(min(maxat*1.8+32-0.5)) as minelement1 from #dbtable# where datetoday = #createodbcdate(datez)#

chartheight="300"
chartwidth="550"
showxgridlines="no"
showygridlines="yes"
gridlines="#gridlines#"
scalefrom="#scalefrom#"
scaleto="#scaleto#"
xaxistitle="Hour of Day"
yaxistitle="#yaxistitle#"
markersize="3"
labelformat="number"
url="http://whatever.com" >

type="line"
seriesColor="green"
paintStyle="shade"
markerStyle="circle"
query="somequery"
itemcolumn="myhour"
valuecolumn="element1" >

coldfusion/6/CFML_Reference/Tags-pt112.htm

rxeno — 2004-11-05T12:18:31

My query returns more than one result for a field, how can I show both grouped by date . The docs say only the last will be displayed???

coldfusion/6/CFML_Reference/Tags-pt112.htm

rxeno — 2004-11-05T12:17:40

My query returns more than one result for a field, how can I show both grouped by date . The docs say only the last will be displayed???

coldfusion/6/CFML_Reference/Tags-pt112.htm

dayton552 — 2004-10-22T08:11:39

When will the sphere chart work? Also, is it possible to add a radar chart?

coldfusion/6/CFML_Reference/Tags-pt112.htm

seattlite — 2004-10-19T09:31:18

Is there a way to set an image as the background for bar charts, or might there be a pre-set textured background already (such as diagonal hash marks)? Thx.

coldfusion/6/CFML_Reference/Tags-pt112.htm

UOBIT — 2004-09-27T14:04:39

Is there any possiblity of creating gifs with cfchart. It would be very handy.

coldfusion/6/CFML_Reference/Tags-pt112.htm

HappyToad — 2004-09-13T04:00:49

I have found the issue as to why cfchart does not work on our windows 2003 server, it appears that when I tell IIS 6 to verify that file exists, then I do not get a chart even though it is being created in the cache directory. Does anyone have a workaround to this? I do not wish to turn off the verifu file exists or I will lose mhy 404 error handler.

coldfusion/6/CFML_Reference/Tags-pt112.htm

RMaxRich — 2004-08-30T04:11:18

In using CFChart in a clustered environment, I am having an issue with the graph showing up. I am using the NAME attribute and creating the file using the CHARSET="ISO-8859-1" writing to a shared UNC path then outputting the graph using the appropriate methods; OBJECT, IMG....

I see that the file is created along with another file, the file I wrote does not show anything but the other file has my graph. Is there a return varriable that can be used to get the name of the file that CFChart is creating so that I would not have to go throught the process of creating the file, which seems to not be working.

Any clues as what I am missing??

Thanks,
Rich

coldfusion/6/CFML_Reference/Tags-pt112.htm

sorrenmt1 — 2004-08-20T15:06:49

I am using a type="step" chart and my x axis labels are being centered between the different steps in the chart. I need these values to line up with the actual x-axis value positions but I cannot seem to do this properly. Is there a way to get this to work? Does this question make sense? It is not easy to describe.

coldfusion/6/CFML_Reference/Tags-pt112.htm

2004-08-06T06:01:50

Barcharts could use an integer format for the y axis.

coldfusion/6/CFML_Reference/Tags-pt112.htm

FAST.hit — 2004-07-22T09:38:08

cfchart suddenly stopped working on our server. It just displays the broken image even though the image files are generated in charting/cache directory. Any ideas how this could be fixed?

coldfusion/6/CFML_Reference/Tags-pt112.htm

halL — 2004-06-22T13:38:15

In response to No Screen name, posted 6/22/04:
You cannot disable the X axis scale labels.

coldfusion/6/CFML_Reference/Tags-pt112.htm

2004-06-22T10:41:47

Is there any way to hide the scale for the x-axis on a chart? I dont want the numbers to be shown.

coldfusion/6/CFML_Reference/Tags-pt112.htm

2004-06-17T13:26:45

Using dynamic data from a CFQUERY there are situations where the particular data results in a pie chart with a visible sliver of white space. The one case that I have seen this is displaying results that add up to 99% due to the fact that the pie slices are rounded to whole percents. However, I have seen some charts on our site that also add to 99% and do not have this sliver. You can see this at work very easily using this simple code. Please tell me if there is anyway to get rid of this.

coldfusion/6/CFML_Reference/Tags-pt112.htm

&&&&&& — 2004-05-07T17:07:51

Is there a way to format the label on the y axis into integer (i.e. I am getting 2.333 and I only want 2)? I tried messing with the different label formats from number to date and I can't come up with the right answer.

coldfusion/6/CFML_Reference/Tags-pt112.htm

2004-04-26T23:58:23

when the ratio of a slice of a pie chart is less than 2 percent. it shows it as 0%.

coldfusion/6/CFML_Reference/Tags-pt112.htm

jrunrandy — 2004-03-16T09:18:12

I don't think so. However, you might try posting your question to the online forums: http://webforums.macromedia.com/coldfusion/

coldfusion/6/CFML_Reference/Tags-pt112.htm

2004-03-16T08:57:19

Can I have 2 y-Axis in cfchart?

coldfusion/6/CFML_Reference/Tags-pt112.htm

jrunrandy — 2004-03-04T07:43:08

Be sure that the jrunscripts directory has both Script and Execute permissions.

coldfusion/6/CFML_Reference/Tags-pt112.htm

2004-03-04T06:20:26

I too am using W2K/IIS with CFMX and am not getting any cfchart output. The image files are created in the cache but the browser waits forever to receive them. I've searched the web and found a couple of other mentions of this problem, but no resolution seems available. Can anyone in the world please help???

Thanks in advance,

Ed

coldfusion/6/CFML_Reference/Tags-pt112.htm

2004-02-06T06:38:45

I am using w2k and cfmx... I am calling cfchart but nothing happens on the page... ? No logs nothing... any ideas?

coldfusion/6/CFML_Reference/Tags-pt112.htm

maddmaster — 2004-01-14T16:55:04

is there a way to format the label into integer (i.e. i am getting 2.333 and i only want 2)? I tried messing with the different label format from number to date and i can come up with the right answer.

coldfusion/6/CFML_Reference/Tags-pt112.htm

campem — 2003-11-18T09:55:43

Why is CFCHART showMarkers ignored for CHARTSERIES type="step"? This type is similar to "line". Also, why, since the markers are showing for CHARTSERIES type="step", can't I control there aspect with CHARTSERIES markerStyle or CHART markerSize.

Also, it would be nice to control the seriesPlacement at the CHARTSERIES level rather than the CHART level. That way I could have a set of CHARTSERIES type="line" not stacked and a set of CHARTSERIES type="bar" stacked on the same graph.

coldfusion/6/CFML_Reference/Tags-pt112.htm

ISLMEDIA — 2003-11-17T19:01:54

Here's a temporary kluge I've used to get around the label width problem with CFCHART pie charts on charts where the label text is dynamic and you can't manually tweak the chart using the CHARTWIDTH.

First calculate the maximum length of a label. Then use that number in a formula to determine the necessary width for the chart. For example in this code snippet I'm getting labels & values from a d/b query:

I then use these width & height variables in the CFCHART tag instead of constants. Using 12pt Arial I get almost perfectly circular pies every time no matter how much the character length of the labels fluctuates. You may have to modify the formula for different font sizes & chart heights.

coldfusion/6/CFML_Reference/Tags-pt112.htm

2003-11-04T05:24:21

I tried setting scalefrom to #CreateDate(Year(Now()),1,1).getTime()# as per d3ut3r0n's post and true enough, CFMX returns:

Could not convert the value 1.0413792E12 to an integer because it cannot fit inside an integer.

Which confirms pretty much all of his findings.

I only upgraded to CFMX about 9 months ago from CF4.5 as it was cheaper than purchasing Corda's charting engine at the time - cfchart was the only reason for my upgrade. its ridiculous that the dates issue has still not been resolved. I've just wasted about 3 days trying to force a timeline based chart to work. (Surely most people's charting needs will include timeline specific charting). Not to mention some other serious restrictions to the tag.

I then upgraded to 6.1 in the hope that this would be fixed. Alas, no.