Stack Overflow
Stack Overflow

Questions tagged [google-datatable]

Google visualization provide API for JavaScript class (DataTable) that represents a two-dimensional, mutable table of values. It is used along with Google charts.

More details can be found in official documentation https://developers.google.com/chart/interactive/docs/reference#DataTable.

36 questions
10
votes
4 answers

How to create the Google DataTable JSON expected source using C#?

How can I create the JSON source expected by the google.visualization.datatable using C#? Obviously using the JavaScriptSerializer is out of the question since the expected JSON has a weird structure as described on the documentation: var dt = new…
Raúl Roa
  • 12,061
  • 13
  • 49
  • 64
10
votes
2 answers

Retain Formatting Using Group By Aggregation in Google Visualization API

Using Google's Visualization API, I use google.visualization.data.group to create sub-tables based on my raw data. My raw data uses the trick of {v:"US", f:"United States"} to display something other than the value, but when I use the aggregation…
jmac
  • 7,078
  • 2
  • 29
  • 57
6
votes
3 answers

how to assign values to TR in google dashboard table

i am using Google Dashboard's table functionality, i want to assign value of id to tr of each row that is created, i have array as follows var data = google.visualization.arrayToDataTable([ ['Name', 'Donuts eaten','id'], ['Michael' ,…
noobie-php
  • 6,817
  • 15
  • 54
  • 101
4
votes
2 answers

place an image inside a Google Visualization Table cell

I am experimenting with the table and example code for Google's Visualization Table. https://google-developers.appspot.com/chart/interactive/docs/gallery/table However, I need to be able to using images (via URL) inside the cells. It seems the…
ikathegreat
  • 2,311
  • 9
  • 49
  • 80
3
votes
2 answers

Creating Google Charts API DataTable From Database of Temperatures and IDs

I'd like to create an Annotation Chart using pool temperature data from the database. You can take a look at the database structure here on sqlfiddle or here on rextester, but to save you the click, here's the structure I'm working with: DROP TABLE…
dhildreth
  • 637
  • 1
  • 6
  • 15
3
votes
2 answers

How to update the underlying google datatable of a google visualization dashboard and refresh the dashboard view?

I created a google visualization dashboard using the Google HTML Service. The underlying datatable (jjdt) is joined from several data tables like jadt2,fa. jjdt =…
Pan Yan
  • 1,622
  • 1
  • 18
  • 21
3
votes
3 answers

Is the getRow() method for Google DataTable deprecated?

I was trying to use the getRow() method (described here) But when running my webpage I get "Uncaught TypeError: Object # has no method 'getRow' ". Has this function been deprecated ? If not, how can I make sure I can use it ? Here is my code…
Chapo
  • 2,563
  • 3
  • 30
  • 60
3
votes
1 answer

Updating Data in Google Visualization DataTable

How do you update data in a google visualization datatable? Example: var data = new google.visualization.DataTable(); data.addColumn('string', 'Name'); data.addColumn('string', 'Occupation'); data.addRow(['Bob', 'Shoe…
Josh Johnson
  • 10,729
  • 12
  • 60
  • 83
2
votes
0 answers

Cannot read property 'valueOf' of null google gannt chart

hello i have been trying to use google gannt charts and it is im rendering this message instead of the chart : Cannot read property 'valueOf' of null× Here is some of my code: This is the script that is building the chart {% for…
neowenshun
  • 860
  • 1
  • 7
  • 21
2
votes
1 answer

Pivot Google DataTable on distinct values

I have a Google DataTable in the following format: +----------+-------+--------+ | time | label | values | +----------+-------+--------+ | 12345678 | foo | 100 | | 12345678 | bar | 200 | | 12345700 | foo | 150 | | 12345700 | bar …
stevendesu
  • 15,753
  • 22
  • 105
  • 182
2
votes
0 answers

Google SQL Pivot make 0 show NULL

I have a pivot table that I need to have return NULL whenever there is not a value in the database. This seems pretty simple when you look at the Google API for their query…
Chris
  • 1,418
  • 2
  • 16
  • 34
2
votes
0 answers

How to show date and time in google chart using google chart data source

I have a REST service that send json object to google chart to draw data in jsp. In REST service side i use google DataTable API to generate google support josn obj.The problem is that i tried to pass my date time value into data table but in google…
gihan-maduranga
  • 4,381
  • 5
  • 41
  • 74
2
votes
1 answer

Get the H-Axis(X-Axis) value of google area chart

In the google chart datatable object, I can get the current select point value(V-Axis/Y-Axis) using datatable.getValue(...). However, if I wanna get the time/date/year from X-Axis(see screenshot). I did not find any datatable's function to achieve…
eded
  • 3,778
  • 8
  • 28
  • 42
1
vote
1 answer

Understanding Google DataTable prefixes

Google DataTable has this string as schema and data values: { cols: [{id: 'task', label: 'Task', type: 'string'}, {id: 'hours', label: 'Hours per Day', type: 'number'}], rows: [{c:[{v: 'Work'}, {v: 11}]}, {c:[{v:…
Egemen Hamutçu
  • 1,602
  • 3
  • 22
  • 34
1
vote
0 answers

Unable to update the auto generated schema in Google Auto ML data set

I am setting up a prediction model using AutoML Tables. Here are the steps that I have completed. Prepare a csv file with relevant data(4 fields). Preprocess the data file.(Remove records with null values and repetitive records). Create a data set…
rajavijayvendan
  • 11
  • 3
1
2 3