问未显示的可视化图表
EN

Stack Overflow用户

提问于 2013-03-29 11:31:29

回答 1查看 111关注 0票数 0

我有下面的代码。我正在尝试创建谷歌可视化列图表，每个栏包含多个数据点。但可视化图表没有显示出来。我得到了类似于ReferenceError的错误: convertToISO没有定义，是错误。请帮帮我。

<script type="text/javascript" src="http://google.com/jsapi"></script>    
<script src="/soap/ajax/19.0/connection.js" type="text/javascript" />  
<script type="text/javascript">      
formatCurrencyLabel = function( value )    
{  
    return "$" +     String(value); 
}
google.load("visualization" , "1" , {package:["ColumnChart"]});
google.setOnLoadCallback(Chart); 

function Chart() 
{
     data.addColumn(‘string’, ‘Timeframe’);        
     data.addColumn(‘number’, ‘Gold’);   
     data.addColumn(‘number’, ‘Platinum’); 
     data.addColumn(‘number’, ‘Millinium’);                         
     sforce.connection.sessionId = ‘{!$Api.Session_ID}’;  
     var date = new Date();
     var dateMin = date.setMonth(date.getMonth() -13);                  
     var  date = new Date();                  
     var dateMax = date.setMonth(date.getMonth() +1);                 
     var soql = "Select id,name,GOLD_Policies_InForce__c, MNS_Policies_InForce__c, 
         PLAT_Policies_InForce__c, Producer_Name__c, Type__c, Producer_Code__c  from
         Analytics__c where Producer_Name__c ='TestABC2' and Period__c ='21' and CreatedDate <"
       + convertToISO(dateMax) + " and convertToISO(CreatedDate) > " + dateMin + " Order by   
        CreatedDate asc ";                  //console.log(soql);         

  result = sforce.connection.query(soql);                
  var it = new sforce.QueryResultIterator(result);        
      while(it.hasNext())
  {                 
   var record = it.next();   
           data.addRow(['record.CreatedDate',
   {v:parseFloat(record.PLAT_Policies_InForce__c), f:
  formatCurrencyLabel(record.PLAT_Policies_InForce__c)},    
 {v:parseFloat(record.PLAT_Policies_InForce__c), f: 
 formatCurrencyLabel(record.PLAT_Policies_InForce__c)},         
 {v:parseFloat(record.GOLD_Policies_InForce__c), f:
 formatCurrencyLabel(record.GOLD_Policies_InForce__c)}         ]);                                    
  }   
  var options = {'title':'Policies Inforce Rolling 13 Months' , legend: 'left' ,                         
 'width':560,                       'height':228,                       'colors' :  
   ['green','orange','#B5C5D7']                  
 }; 
    var chart = new google.visualization.ColumnChart(document.getElementById('chart'));
     chart.draw(data , options);  
};    
</script>       
  <body><div id="chart"></div></body>

javascript

visualforce

回答 1

Stack Overflow用户

发布于 2013-04-01 13:48:57

问题是，在下面的代码行中，您尝试以javascript函数调用的形式运行convertToISO(dateMax)，而不是部分SQL查询。您还没有定义任何这样的函数，因此JavaScript引擎抱怨您正在尝试运行一个未定义的函数

var soql = "Select id,name,GOLD_Policies_InForce__c, MNS_Policies_InForce__c, 
     PLAT_Policies_InForce__c, Producer_Name__c, Type__c, Producer_Code__c  from
     Analytics__c where Producer_Name__c ='TestABC2' and Period__c ='21' and CreatedDate <"
   + convertToISO(dateMax) + " and convertToISO(CreatedDate) > " + dateMin + " Order by   
    CreatedDate asc ";

应：

var soql = "Select id,name,GOLD_Policies_InForce__c, MNS_Policies_InForce__c, 
     PLAT_Policies_InForce__c, Producer_Name__c, Type__c, Producer_Code__c  from
     Analytics__c where Producer_Name__c ='TestABC2' and Period__c ='21' and CreatedDate < 
     convertToISO(" + dateMax + ") and convertToISO(CreatedDate) > " + dateMin + " Order by       
     CreatedDate asc ";

票数 0

页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持

原文链接：

https://stackoverflow.com/questions/15702351

复制

相似问题

问未显示的可视化图表
EN

回答 1

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问未显示的可视化图表EN

回答 1

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问未显示的可视化图表
EN