Number Column Value is not Interpreted properly.

16 views
Skip to first unread message

Naresh Kumar Sanda

unread,
Oct 24, 2016, 10:46:08 AM10/24/16
to Google Visualization API
Hi ,

My sales value is intreperted wrongly in the below snippet ,Do we have any limit of number column range.

Sales for the year 2004 is 10004645366456458655 value representing is 10004645366456460000
Please suggest me as Am not aware of the column ranges.
 
  <html>
  <head>
    <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
    <script type="text/javascript">
      google.charts.load('current', {'packages':['corechart']});
      google.charts.setOnLoadCallback(drawChart);

      function drawChart() {
        var data = google.visualization.arrayToDataTable([
          ['Year', 'Sales', 'Expenses'],
          ['2004',  10004645366456458655,      400],
          ['2005',  1170,      460],
          ['2006',  660,       1120],
          ['2007',  1030,      540]
        ]);

        var options = {
          title: 'Company Performance',
          curveType: 'function',
          legend: { position: 'bottom' }
        };

        var chart = new google.visualization.LineChart(document.getElementById('curve_chart'));

        chart.draw(data, options);
      }
    </script>
  </head>
  <body>
    <div id="curve_chart" style="width: 900px; height: 500px"></div>
  </body>
</html>


Thanks & Regards,
Naresh

Daniel LaLiberte

unread,
Oct 24, 2016, 11:13:32 AM10/24/16
to Google Visualization API
Naresh,

It is not a limitation in Google Charts exactly but JavaScript number representation, which is limited to about 16 digits.  Your number has 19, so the low-order digits get dropped.


However, what you can do is provide a formatted representation of your number with full precision.  Replace your number with {v: 10004645366456458655, f: "10004645366456458655"} and that string will show up in tooltips. The loss of precision won't matter for the drawing.


--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsub...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/d61ab66a-d608-4850-8e51-3390c529b94e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--
Reply all
Reply to author
Forward
0 new messages