Integrating Visualforce And GoogleCharts


Google Charts is a very powerful, free javascript library that can be used to produce a wide variety of colorful and useful charts, from pie charts to histograms. Combined with Visuaforce, the  Google Charts can offer more flexibility and distribution potential than using a dashboard. Since the charts are generated through a URL, the visualizations can be shared and embedded wherever images are permitted.

In this post, we will focus on combining Visualforce to Google Charts.Below is an example,
Visualforce Page:
<apex:page controller="Goal" sidebar="true" showHeader="true" showChat="true"> 
    <apex:includeScript id="a" value="https://www.google.com/jsapi" />
    <div id="chartBlock" />
    <script type="text/javascript">
    google.load('visualization', '1.0', {'packages':['corechart']});
    google.setOnLoadCallback(initCharts);
    function initCharts() {       
        Goal.loadGoals(
            function(result, event){ 
                var visualization = new google.visualization.ColumnChart(document.getElementById('chartBlock'));
                var data = new google.visualization.DataTable();
                data.addColumn('string', 'Sales Reps');
                data.addColumn('number', 'Goals');
                data.addColumn('number', 'Completed');   
                for(var i =0; i<result.length;i++){
                    var r = result[i];
                    data.addRow([r.Name, r.Goals__c, r.Completed__c]);
                }
                visualization.draw(data, {legend : {position: 'top', textStyle: {color: 'blue', fontSize: 10}}, width:window.innerWidth,vAxis:{textStyle:{fontSize: 10}},hAxis:{textStyle:{fontSize: 10},showTextEvery:1,slantedText:false}});
            }, {escape:true});
    }
    </script>
</apex:page>

  •   <apex:includeScript id="a" value="https://www.google.com/jsapi" /> Using this Apex Component we can include Free Google Charts JavaScript URL in Visualforce.


Apex Controller:
global with sharing class Goal {
    @RemoteAction
    global static Sales_Reps__c[] loadGoals() {
        return [select  Name, Goals__c, Completed__c from Sales_Reps__c limit 5];
    } 

}
@RemoteAction :The RemoteAction annotation provides support for Apex Methods used in Visualforce to be called via JavaScipt.
The RemoteAction annotation provides support for Apex methods used in Visualforce to be called via JavaScript.
OutCome:






Comments

Post a Comment

Popular posts from this blog

Configur Docusign For Salesforce

Image
DocuSign For Salesforce The basic steps are : Step 1:Sign in or create a Docusign account ( Refer  sfdcsireesha.blogspot.in --Docusign Integration With Salesforce). Step 2:Connect salesforce to Docusign( Refer  sfdcsireesha.blogspot.in --Docusign Integration With Salesforce). . Steps To Configure Docusign For Salesforce: Step 1:  After installing the DocuSign for Salesforce managed package, select the  DocuSign Admin  tab in Salesforce to bring up the DocuSign Log In view Step 2: Log in to your DocuSign Account:  Use an existing DocuSign admin account.                                                          Or Step 2: Sign up for a Free DocuSign Trial:  This creates a new account with a complementary 30-day free trial.  The free trial account is automatically directed to the DocuSign Production environment Step 3: Connect your DocuSign account with your Salesforce account, adding DocuSign as a Trusted Network in Salesforce. Enter your Salesforce credentials,
Read more

How To Make DataTable Column Resizable

Image
First, we will use the dummy table shared by the  Lightning Design System . We need to store the original width of the selected column to calculate the new width for which we have defined the oldWidth attribute to store the value. We also need the distance of the selected column width from the left of the screen to identify the start point from where user start to drag the column. We have used mouseStart attribute for the same. We have used two mouse events to identify when user start to drag and when user is dragging the column for adjusting the width. onmousedown  will be fired when user click on the column divider element and ondrag  will be fired when user is dragging th . Component : <aura:component implements="force:appHostable,flexipage:availableForAllPageTypes,flexipage:availableForRecordHome,force:hasRecordId" access="global" >     <aura:attribute name="mouseStart" type="string" />     <aura:attribute name="
Read more

Lightning:recordForm - Lightning Data Service

Image
Lightning:recordForm is a very powerful component for editing, viewing and adding a record in lightning and combines both lightning:recordEditForm and lightning:recordViewForm. Here is an example lightning component for lightning:recordForm. Lightning Component:- <aura:component implements="flexipage:availableForRecordHome,force:hasSObjectName,force:hasRecordId" access="global" >     <aura:attribute name="fieldsList" type="String[]" default="['Id', 'Name', 'BillingAddress', 'Phone' , 'Type']"/>     <div class="THIS">                <lightning:recordForm                               recordId="{!v.recordId}"                               objectApiName="{!v.sObjectName}"                               fields="{!v.fieldsList}"                               columns="2"                               mode="View&qu
Read more