title: Google App Scripts and HtmlService and Charts
body: <p>Basically I am creating an app where I get data from Google Analytics store it in spreadsheets so i can render this into a nice looking chart. (Thats the end goal) What I created was an html page that has 2 input boxes with dates "from date" and "to date". With 2 buttons "reache" and "filter" If you recache the data it will run the analytics function to gather the data and store it and filter will just use a google query to get the data in the date range from the cache.</p>
  
  <p>The reache works fine, when i click it, the function runs and updates the spreadsheet. The filter function on the other hand does not work, I am unable to add google charts</p>
  
  <pre><code>    &lt;script type="text/javascript" src="http://www.google.com/jsapi"&gt;&lt;/script&gt;
  &lt;script type="text/javascript"&gt;
    google.load('visualization', '1', {packages: ['table']});
  &lt;/script&gt;
  </code></pre>
  
  <p>Reading this (<a href="http://googleappsdeveloper.blogspot.ca/2013/03/retiring-a-few-apps-script-components.html" rel="nofollow">http://googleappsdeveloper.blogspot.ca/2013/03/retiring-a-few-apps-script-components.html</a>) I found out its best not to use the UiService and rather stick to the Html Service because the ui service might eventually be unsupported. ( i know its possible to use the uiservice to make the charts but didnt read much on it because of the above article figured I would focus on using HtmlService.</p>
  
  <p>Reading this (<a href="https://code.google.com/p/google-apps-script-issues/issues/detail?id=2949" rel="nofollow">https://code.google.com/p/google-apps-script-issues/issues/detail?id=2949</a>) I am unable to use google visualization to take my spreadsheet data and generate a view.</p>
  
  <p>Does anyone have any suggestions for me on how I am to go about creating views using google visualization class. Maybe I am doing this wrong? Possibly a link or 2 for me to read.</p>