Sgvizler has moved to github. This site and its repository will no longer be maintained.
wiki:Sgvizler/Chart/GoogleVisualizationTable

This chart and its examples are implemented using Sgvizler 0.6, for version 0.5 see Sgvizler/0.5/DesigningQueries.

source:misc/image/screenshot/gTable.png

Google Table

Draws a table, but a bit more fancy than a regular HTML table: columns are aligned according to contents, e.g., numbers go right and text left; automatic scrolling when overflow of HTML container; and hovering effects.

Chart ID
google.visualization.Table
External reference
 https://developers.google.com/chart/interactive/docs/gallery/table
Other similiar charts
Sgvizler/Chart/sgvizler.visualization.Table?

Query result set format

Any number of columns on any format.

See  Google's page on this chart for more details.

Chart options

See  Google's page on this chart for all available options.

See Sgvizler/Using, or the example(s) below, for how to set options.

Live Example

Query: The total production of oil, gas, condensate, NGL and water per year on Ekofisk.

HTML

<div id="ex"
   data-sgvizler-endpoint="http://sws.ifi.uio.no/sparql/npd"
   data-sgvizler-query="
        SELECT ?year ?Oil_millSm3 ?Gas_billSm3 ?NGL_millSm3 ?Condensate_millSm3 ?Water_millSm3 
        { ?period a npdv:FieldProductionPeriod ; 
              npdv:hasField &lt;http://sws.ifi.uio.no/npd/field/Ekofisk&gt; ; 
              npdv:year ?year ; 
              npdv:producedNetOilMillSm3 ?Oil_millSm3 ; 
              npdv:producedNetGasBillSm3 ?Gas_billSm3 ; 
              npdv:producedNetNGLMillSm3 ?NGL_millSm3 ; 
              npdv:producedNetCondensateMillSm3 ?Condensate_millSm3 ; 
              npdv:producedWaterMillSm3 ?Water_millSm3 ;
              OPTIONAL{ ?period npdv:month ?month } . 
              FILTER (!bound(?month)) 
         } ORDER BY ?year" 
   data-sgvizler-chart="google.visualization.Table"
   style="width:400px; height:265px; border:1px solid black; display: inline-block;"></div>

Result

The result of the HTML above (left), and a sgvizler.visualization.Table? rendering of the same query (right).


Notes

See Sgvizler/Setup for how Sgvizler is setup on this site.

Note that the query and visualization is ment to show the use of Sgvizler, and may not be the most appropriate way of illustrating this result set.

Feedback

Tickets

No results

User Examples and Comments

Users, please insert (links to) other examples of usage of this Sgvizler chart, or relevant comments here.