Solved

an issue with <cfchart value

Posted on 2014-12-30
5
107 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

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Hi, I will be creating today a basic tutorial on how we can create a Mail Custom Function and use it where ever we want. The main advantage about creating a custom function is that we can accommodate a range of arguments to pass to the Function and …
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 …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

828 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