[visualization-api] New Sheets setQuery Select Where for dates help needed
Need some query.setQuery help when using new Google Sheets. var selectStatement = 'SELECT A, B, C WHERE A = 1/9/2014 '; // A is date column with format 1/1/2014 console.log(Select= +selectStatement); query.setQuery(selectStatement); Syntax is successful, but results are nothing. -- 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+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
[visualization-api] Re: New Sheets setQuery Select Where for dates help needed
Here is a snippet screenshot of column A. Here are results *without* the WHERE clause to show available data: On Monday, August 11, 2014 1:38:42 PM UTC-4, Steve Webster wrote: Need some query.setQuery help when using new Google Sheets. var selectStatement = 'SELECT A, B, C WHERE A = 1/9/2014 '; // A is date column with format 1/1/2014 console.log(Select= +selectStatement); query.setQuery(selectStatement); Syntax is successful, but results are nothing. -- 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+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
Re: [visualization-api] Re: What are the exact chartType names? What chartTypes are available for use in a dashboard?
Another exception appears to be SanKey. I believe this is a known bug that I saw on issue tracker which submitted in February. On Mon, Aug 4, 2014 at 7:47 PM, Andrew Gallant agall...@google.com wrote: The chartType property takes a string referencing the google.visualization object property for the chart you want to draw. For example, if you want to draw a Line Chart, the normal Line Chart object is: google.visualization.LineChart so when using a ChartWrapper, you would set the chartType property to LineChart. This works for any chart that is a part of the google.visualization object (see the gallery https://developers.google.com/chart/interactive/docs/gallery for a complete list). You can get the object name from the chart documentation, though in most cases it is simply the name of the chart, CamelCased (that is, capitalize the first letter of each word), with spaces removed, eg: Geo Chart = GeoChart Bubble Chart = BubbleChart Stepped Area Chart = SteppedAreaChart The one major exception to that rule is the Donut Chart, which is actually constructed using a Pie Chart, and thus you would use PieChart to build one. If you are using 3rd party visualizations, the chartType parameter takes the fully qualified object reference as a string. As an example, if I have a custom chart in the object: library.charts.myChart then the chartType parameter would be library.charts.myChart. On Monday, August 4, 2014 12:03:34 PM UTC-4, codejak wrote: Hi! I can't find a document that defines the full set of chart types and the exact name to be used for the chartType wrapper property. Is there such a list or some other rule of finding out? Can all chart types actually be used in a ChartWrapper? I have not been able to make it work for a calendar for example. TIA for any pointers! Matt -- 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+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout. -- 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+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
Re: [visualization-api] Visualization Playground Broken Link
Is it possible to have a temporary code samples using JSFiddle (quick and dirty) and later deliver your polished solution? On Thu, Jul 31, 2014 at 10:14 AM, 'Thomas Rybka' via Google Visualization API google-visualization-api@googlegroups.com wrote: This is affecting the whole playground. We are working on alternative methods of hosting more interactive sample charts (that you can edit the code and see running in the same sandbox). Thomas Rybka | Software Engineer | try...@google.com | GViz On Thu, Jul 31, 2014 at 8:44 AM, Ishwar Kabra ishwar@gmail.com wrote: Hi Jon, When will it be available for developers? Thanks On Wednesday, July 30, 2014 7:25:52 PM UTC+5:30, orw...@google.com wrote: The playground has been taken offline for security reasons. Sorry, Jon On Wed, Jul 30, 2014 at 4:37 AM, Visual1zer flas...@gmail.com wrote: Thanks for the update Cheers, On Tuesday, 29 July 2014 14:22:07 UTC+1, orw...@google.com wrote: Yep, we're investigating a fix. Jon On Tue, Jul 29, 2014 at 6:25 AM, Visual1zer flas...@gmail.com wrote: Hi all, the Visualization Link appears to be broken: http://code.google.com/apis/ajax/playground/?type=visualization Is it being moved to a new address or soon to be removed from the Google Charts portal? Cheers, -- 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 scr...@googlegroups.com. To post to this group, send email to google-visua...@googlegroups.com . Visit this group at http://groups.google.com/group /google-visualization-api. For more options, visit https://groups.google.com/d/optout. -- 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+unsubscr...@googlegroups.com. To post to this group, send email to google-visua...@googlegroups.com. Visit this group at http://groups.google.com/ group/google-visualization-api. For more options, visit https://groups.google.com/d/optout. -- 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+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout. -- 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+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout. -- 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+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
Re: [visualization-api] Visualization Playground Broken Link
Jon, how soon could the sample code be made available for at least all the charts? On Wednesday, July 30, 2014 9:55:52 AM UTC-4, orw...@google.com wrote: The playground has been taken offline for security reasons. Sorry, Jon On Wed, Jul 30, 2014 at 4:37 AM, Visual1zer flas...@gmail.com javascript: wrote: Thanks for the update Cheers, On Tuesday, 29 July 2014 14:22:07 UTC+1, orw...@google.com wrote: Yep, we're investigating a fix. Jon On Tue, Jul 29, 2014 at 6:25 AM, Visual1zer flas...@gmail.com wrote: Hi all, the Visualization Link appears to be broken: http://code.google.com/apis/ajax/playground/?type=visualization Is it being moved to a new address or soon to be removed from the Google Charts portal? Cheers, -- 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+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
[visualization-api] Replace Playground with Code Examples
Since the Charts Playground is no longer available due to security concerns, could you make all the code examples available. Perhaps copy the playground source, remove the results section (at bottom) thereby removing the security concern (assumption), and just the left column list and right column of code samples remain. My two cents :) -- 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+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.