Quickbase Posterous Blog Entry

by dandiebolt

HTML

<script src="https://www.quickbase.com/db/befe2yy7d?a=dbpage&amp;pagename=date.js"></script>
<script src="https://www.quickbase.com/db/befe2yy7d?a=dbpage&amp;pagename=jgcharts.js"></script>
<h2>Number of Posts to Old Forum Per Day of Week</h2>
<div id="mychart"></div>

JavaScript

var url = "";
url += "https://www.quickbase.com/db/8emtadvk";
url += "?act=API_GenResultsTable";
url += "&query={1.OAF.01-01-2009}AND{1.OBF.12-31-2009}";
url += "&clist=1";
url += "&jsa=1";

var dayofweek;
var counts={Mon: 0, Tue: 0, Wed: 0, Thu: 0, Fri: 0, Sat: 0, Sun: 0};
var api;
var data, axis_labels, options;

$.getScript(url,function(){
 for (var i=0; i<qdb_numrows; i++) {
  dayofweek = Date.parse(qdb_data[i][0]).toString("ddd"); 
  counts[dayofweek]++;
 }
 api = new jGCharts.Api(); 
 
 data = [counts["Mon"], counts["Tue"], counts["Wed"], counts["Thu"], counts["Fri"], counts["Sat"], counts["Sun"]];
 axis_labels = ["Mon", "Tue", "Wed", "Thu", "Fri", "Sat", "Sun"];
 
 options = { 
  data: data,
  axis_labels: axis_labels,
  size: "300x200",
  type: "bvg"
 };
    
 $("<img>") 
  .attr("src", api.make(options))
  .appendTo("#mychart");
});