Hello;
I am using Google Calendar Chart in which I am displaying Google Calendar Chart Tooltip as Date : Amt .
For which there is two column :
var data = new google.visualization.DataTable();
data.addColumn({ type: 'date', id: 'Date' });
data.addColumn({ type: 'number', id: 'BaseAmount' });
And add to DataTable data as
str = new Array(new Date(dateFormat),Number(dataValues[i].BaseAmount)); //
alert(str);
data.addRows([str]);
But it is successfully getting displayed on the google Calendar chart. The only issue is that if there is multiple data on a particular date then it displays the last data entered in Datatable.
CloseDate BankName BaseAmount
2016-09-11 HSBC BANK 8696766.375000
2017-03-30 KOTAK 9131605.034900
2017-04-16 Yes Bank 6600000.000000
2017-04-20 IDFC Bank 7491000.000000
2017-04-25 HDFC BANK 7491000.000000
2017-04-28 HSBC BANK 3300000.000000
2017-04-28 Yes Bank 1320000.000000
2017-04-30 HSBC BANK 13000000.000000
2017-05-03 IDFC Bank 83950556.000000
2017-05-06 IDFC Bank 83942940.000000
2017-05-24 Yes Bank 3300000.000000
As u can see on date 2017-04-28 there is two data available and its displaying last data i.e., 1320000.000 .Isit possible to display
either like this 2017-04-28 :
HSBC BANK 3300000.000000
Yes Bank 1320000.000000