Multiple data on a particular Date.

26 views
Skip to first unread message

Neha Prasad

unread,
Apr 18, 2017, 5:37:14 AM4/18/17
to Google Visualization API
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


Reply all
Reply to author
Forward
0 new messages