Solved

an issue with <cfchart value

Posted on 2014-12-30
5
106 Views
Last Modified: 2015-01-12
Hi,

I am getting an error that says this:

Attribute validation error for CFCHARTDATA. The value of the VALUE attribute is invalid. The value cannot be converted to a numeric because it is not a simple value.Simple values are booleans, numbers, strings, and date-time values. 
The error occurred on line 201.

Open in new window





     <cfchart
         format="html"
       query="GetAppType"
showlegend="true"

         pieslicestyle="solid"
         chartheight="800" chartwidth="950" >
	<cfchartseries
	             type="pie"
	             serieslabel="Applications Type"
	             seriescolor="blue">
                 
                 <CFIF isDefined("GetAppType") and #GetAppType.RecordCount# gt 0>
                <cfloop query="GetAppType">
                       <cfchartdata item="#GetAppType.ApplicationType#" 
                        value="#GetAppType.Percentage#">        
              	</cfloop>
                                
           	</CFIF>

	</cfchartseries>
</cfchart>

Open in new window



The problem is with my  value="#GetAppType.Percentage#">        
the output of this

#GetAppType.Percentage#      

output is

0.13%
2.83%
40.89%

If I take the percent sign out, then it will work but I want the percent sign in the value.

Thank you for your help
0
Comment
Question by:lulu50
  • 3
  • 2
5 Comments
 
LVL 39

Accepted Solution

by:
gdemaria earned 500 total points
ID: 40524331
You can wrap val() around the value to use only  the numeric part of it.

As far as showing the % on the chart, you need to choose a chart style that is expecting a percent (that is, the percent is part of the chart format, not part of the value passed).

<cfchartdata item="#GetAppType.ApplicationType#"
                        value="#val(GetAppType.Percentage)#">
0
 

Author Comment

by:lulu50
ID: 40524456
gdemaria,

I'm not getting the error anymore after adding the val() but for some reason I cannot see the % sign

can I do something like this

#val(GetAppType.Percentage)# + '%'">
0
 
LVL 39

Expert Comment

by:gdemaria
ID: 40524527
No unfortunately, that won't work.   The item tag is expecting a number.  

To get the percent sign to appear it is part of one of the parameters or the style.

I'm so sorry,  the family is waiting for me in the car, we are heading out of state for a couple days.  Sorry to leave you hanging, I don't recall which parameter it is, but it is some type of format or style that you have to apply, it is not in the number.  
Sorry !
0
 

Author Comment

by:lulu50
ID: 40524694
have fun!!!

I'll wait for you because most likely I wont know how to fix it.
0
 

Author Closing Comment

by:lulu50
ID: 40545073
Thank you
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The technique is by far very Simple! How we can export the ColdFusion query results to DOC file?  Well before writing this I researched a lot in Internet but did not found a good Answer anyways!  So i thought now i should share my small snippet w…
Recently while working on a project I got a very annoying cfdocument has no body error message. I had never seen this error before. So I checked the code. The code was pretty simple; it was Just showing me the cfdocumnt tag and inside that tag a …
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question