Re: [visualization-api] Re: SharePoint Google Dashboard
Thanks! I made it a single call. Still not sure why the chart shows for a
second and then the pge reloads
On Thu, May 8, 2014 at 11:25 PM, Andrew Gallant asgallant...@gmail.comwrote:
It looks like your queries run, the table and chart draw, and then the
page reloads. I don't see anything in your chart code that would cause a
page reload, so it is likely somewhere else. The only problem I see is
with your google.load calls, and it wouldn't cause the page to reload. You
should have a single call that loads two packages rather than two load
calls:
google.load(visualization, 1,
{packages:[corechart]});google.load(visualization, 1,
{packages:[table]});
should be:
google.load(visualization, 1, {packages:[corechart, table]});
On Thursday, May 8, 2014 3:11:47 PM UTC-4, TheInnovator wrote:
Any body know why my charts are not rendering?
My data is coming from a sharepoint list (http://isaac.issharepoint.
com/Lists/Ticketing%20System/AllItems.aspx).
Here's my dashboard: http://isaac.issharepoint.com/Web%20Part%20Page/
solCenterDashboard.aspx
Attached is my code.
Thanks for any help you can provide.
--
You received this message because you are subscribed to a topic in the
Google Groups Google Visualization API group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/google-visualization-api/rL25KX0k_N4/unsubscribe
.
To unsubscribe from this group and all its topics, 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.
--
-Isaac-
http://twitter.com/#!/feedy0urmind
You are today where your thoughts have brought you; you will be tomorrow
where your thoughts take you.
- James Allen
--
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: 0 rows sometimes. Inconsistent datatable query result
Are you checking the query reponse's isError function?
On Thursday, May 8, 2014 5:34:13 PM UTC-4, John Richardson wrote:
Hello,
Google fusion tables sometimes returns 0 rows even though the next time I
execute the same query it returns the correct number of rows. This often
happens when I don't execute a query for a few minutes. It's almost like
it times out but still returns a valid SQL response. Here is an example
SQL statement:
http://www.google.com/fusiontables/gvizdata?tq=SELECT 'loan_status' as
'Loan Status', count() as 'Total' FROM
11-6aP_3sWAtvCjhLtX7oj50gQrA3Q4lDdLEmGDIJ WHERE grade IN ('A') GROUP BY
'loan_status' ORDER BY 'loan_status' ASC
Occasionally, the query will timeout, and return the correct error message
from getMessage that I can catch. However, when 0 rows are returned there
is no warning or error message to catch even though I know there should be
rows.
I am doing a data.getNumberOfRows(); to determine if the result is valid
containing rows. However, there are cases when 0 rows is the correct
result. Is there any way to ensure that the query.send() returns the
correct query result? I am confused why there is this inconsistency.
Thanks for your help in advance,
John
--
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: Pie Chart (Pie Slice labels)
Is it possible to change the percentage on the leader lines to whole numbers? http://jsfiddle.net/asgallant/FN36W/88/ On Tue, May 6, 2014 at 4:43 PM, Andrew Gallant asgallant...@gmail.comwrote: The legend, in this case, is the labels on the leader lines, so if you wanted a second legend, you would need to create it manually in HTML. On Tuesday, May 6, 2014 4:25:52 PM UTC-4, TheInnovator wrote: Can i still have the legends line up on the side or bottom? On Tue, May 6, 2014 at 12:19 PM, Andrew Gallant asgall...@gmail.comwrote: There are no options that will add leader lines for values like that, but you can do something similar by setting the legend.position option to labeled: http://jsfiddle.net/asgallant/FN36W/88/ On Tuesday, May 6, 2014 11:35:11 AM UTC-4, TheInnovator wrote: I have a pie chart that has about 15+ slices. http://jsfiddle.net/FN36W/86/ How can I get all the labels shown like so https://lh6.googleusercontent.com/-ml2wqxTWbyQ/U2kBBgKaoEI/Ajg/ptp3Q3v0zKs/s1600/pie.PNG Thanks! -- You received this message because you are subscribed to a topic in the Google Groups Google Visualization API group. To unsubscribe from this topic, visit https://groups.google.com/d/ topic/google-visualization-api/LgjhFiCWT5Q/unsubscribe. To unsubscribe from this group and all its topics, 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. -- -Isaac- http://twitter.com/#!/feedy0urmind You are today where your thoughts have brought you; you will be tomorrow where your thoughts take you. - James Allen -- You received this message because you are subscribed to a topic in the Google Groups Google Visualization API group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-visualization-api/LgjhFiCWT5Q/unsubscribe . To unsubscribe from this group and all its topics, 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. -- -Isaac- http://twitter.com/#!/feedy0urmind You are today where your thoughts have brought you; you will be tomorrow where your thoughts take you. - James Allen -- 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] Querying a Spreadsheet: Not correct when only string values
So I ran into something I was not expecting. If I try to query a spreadsheet that has columns that only have strings (no numbers), it doesn't grab/load the information correctly. It combines all rows into one. After chasing the wrong squirrel for a while, I figured out if I add a column and fill it with numbers, it loads and displays the table fine. Here's a fiddle: http://jsfiddle.net/siobahnv/s5vqg/ Is this a bug? Or did I just miss something in the documentation? -- 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: Pie Chart (Pie Slice labels)
No. On Friday, May 9, 2014 1:25:19 PM UTC-4, TheInnovator wrote: Is it possible to change the percentage on the leader lines to whole numbers? http://jsfiddle.net/asgallant/FN36W/88/ On Tue, May 6, 2014 at 4:43 PM, Andrew Gallant asgall...@gmail.comjavascript: wrote: The legend, in this case, is the labels on the leader lines, so if you wanted a second legend, you would need to create it manually in HTML. On Tuesday, May 6, 2014 4:25:52 PM UTC-4, TheInnovator wrote: Can i still have the legends line up on the side or bottom? On Tue, May 6, 2014 at 12:19 PM, Andrew Gallant asgall...@gmail.comwrote: There are no options that will add leader lines for values like that, but you can do something similar by setting the legend.position option to labeled: http://jsfiddle.net/asgallant/FN36W/88/ On Tuesday, May 6, 2014 11:35:11 AM UTC-4, TheInnovator wrote: I have a pie chart that has about 15+ slices. http://jsfiddle.net/FN36W/86/ How can I get all the labels shown like so https://lh6.googleusercontent.com/-ml2wqxTWbyQ/U2kBBgKaoEI/Ajg/ptp3Q3v0zKs/s1600/pie.PNG Thanks! -- You received this message because you are subscribed to a topic in the Google Groups Google Visualization API group. To unsubscribe from this topic, visit https://groups.google.com/d/ topic/google-visualization-api/LgjhFiCWT5Q/unsubscribe. To unsubscribe from this group and all its topics, 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. -- -Isaac- http://twitter.com/#!/feedy0urmind You are today where your thoughts have brought you; you will be tomorrow where your thoughts take you. - James Allen -- You received this message because you are subscribed to a topic in the Google Groups Google Visualization API group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-visualization-api/LgjhFiCWT5Q/unsubscribe . To unsubscribe from this group and all its topics, send an email to google-visualization-api+unsubscr...@googlegroups.com javascript:. To post to this group, send email to google-visua...@googlegroups.comjavascript: . Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout. -- -Isaac- http://twitter.com/#!/feedy0urmind You are today where your thoughts have brought you; you will be tomorrow where your thoughts take you. - James Allen -- 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: Pie Chart (Pie Slice labels)
Ok. Thanks! On Fri, May 9, 2014 at 1:40 PM, Andrew Gallant asgallant...@gmail.comwrote: No. On Friday, May 9, 2014 1:25:19 PM UTC-4, TheInnovator wrote: Is it possible to change the percentage on the leader lines to whole numbers? http://jsfiddle.net/asgallant/FN36W/88/ On Tue, May 6, 2014 at 4:43 PM, Andrew Gallant asgall...@gmail.comwrote: The legend, in this case, is the labels on the leader lines, so if you wanted a second legend, you would need to create it manually in HTML. On Tuesday, May 6, 2014 4:25:52 PM UTC-4, TheInnovator wrote: Can i still have the legends line up on the side or bottom? On Tue, May 6, 2014 at 12:19 PM, Andrew Gallant asgall...@gmail.comwrote: There are no options that will add leader lines for values like that, but you can do something similar by setting the legend.position option to labeled: http://jsfiddle.net/asgallant/FN36W/88/ On Tuesday, May 6, 2014 11:35:11 AM UTC-4, TheInnovator wrote: I have a pie chart that has about 15+ slices. http://jsfiddle.net/FN36W/86/ How can I get all the labels shown like so https://lh6.googleusercontent.com/-ml2wqxTWbyQ/U2kBBgKaoEI/Ajg/ptp3Q3v0zKs/s1600/pie.PNG Thanks! -- You received this message because you are subscribed to a topic in the Google Groups Google Visualization API group. To unsubscribe from this topic, visit https://groups.google.com/d/to pic/google-visualization-api/LgjhFiCWT5Q/unsubscribe. To unsubscribe from this group and all its topics, 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. -- -Isaac- http://twitter.com/#!/feedy0urmind You are today where your thoughts have brought you; you will be tomorrow where your thoughts take you. - James Allen -- You received this message because you are subscribed to a topic in the Google Groups Google Visualization API group. To unsubscribe from this topic, visit https://groups.google.com/d/ topic/google-visualization-api/LgjhFiCWT5Q/unsubscribe. To unsubscribe from this group and all its topics, 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. -- -Isaac- http://twitter.com/#!/feedy0urmind You are today where your thoughts have brought you; you will be tomorrow where your thoughts take you. - James Allen -- You received this message because you are subscribed to a topic in the Google Groups Google Visualization API group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-visualization-api/LgjhFiCWT5Q/unsubscribe . To unsubscribe from this group and all its topics, 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. -- -Isaac- http://twitter.com/#!/feedy0urmind You are today where your thoughts have brought you; you will be tomorrow where your thoughts take you. - James Allen -- 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: Querying a Spreadsheet: Not correct when only string values
That looks like a bug to me. You can file a bug report on it herehttp://code.google.com/p/google-visualization-api-issues/issues/list, though it's technically a bug with the spreadsheets rather than the Visualization API. On Friday, May 9, 2014 1:28:08 PM UTC-4, HRansome wrote: So I ran into something I was not expecting. If I try to query a spreadsheet that has columns that only have strings (no numbers), it doesn't grab/load the information correctly. It combines all rows into one. After chasing the wrong squirrel for a while, I figured out if I add a column and fill it with numbers, it loads and displays the table fine. Here's a fiddle: http://jsfiddle.net/siobahnv/s5vqg/ Is this a bug? Or did I just miss something in the documentation? -- 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: 0 rows sometimes. Inconsistent datatable query result
Yes, I am checking with the response.isError() function as well as
hasWarning. Both do not capture any problems. However, I did notice that
when i convert the datatable to JSON, I see that the number of rows
(totalrows value) is actually -1 even though the getNumberOfRows() is 0. I
was then able to get this value with getTableProperty(totalrows). When
the query result should be 0, the totalrows property is 0. So, this allows
me to determine there is a problem. However, I don't understand why
fusiontables returns a -1 value for the same query on occasion. Any ideas?
John
On Thursday, May 8, 2014 5:34:13 PM UTC-4, John Richardson wrote:
Hello,
Google fusion tables sometimes returns 0 rows even though the next time I
execute the same query it returns the correct number of rows. This often
happens when I don't execute a query for a few minutes. It's almost like
it times out but still returns a valid SQL response. Here is an example
SQL statement:
http://www.google.com/fusiontables/gvizdata?tq=SELECT 'loan_status' as
'Loan Status', count() as 'Total' FROM
11-6aP_3sWAtvCjhLtX7oj50gQrA3Q4lDdLEmGDIJ WHERE grade IN ('A') GROUP BY
'loan_status' ORDER BY 'loan_status' ASC
Occasionally, the query will timeout, and return the correct error message
from getMessage that I can catch. However, when 0 rows are returned there
is no warning or error message to catch even though I know there should be
rows.
I am doing a data.getNumberOfRows(); to determine if the result is valid
containing rows. However, there are cases when 0 rows is the correct
result. Is there any way to ensure that the query.send() returns the
correct query result? I am confused why there is this inconsistency.
Thanks for your help in advance,
John
--
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: Querying a Spreadsheet: Not correct when only string values
Woo it's not me! And thank you. I'm more than happy to post the bug report to spreadsheets rather than Visualization API if you could point me in the right direction. Figuring out how to customize the CSS to a control slider bar has been less painful than trying to figure out where to post a bug report. On Friday, May 9, 2014 10:46:15 AM UTC-7, Andrew Gallant wrote: That looks like a bug to me. You can file a bug report on it herehttp://code.google.com/p/google-visualization-api-issues/issues/list, though it's technically a bug with the spreadsheets rather than the Visualization API. On Friday, May 9, 2014 1:28:08 PM UTC-4, HRansome wrote: So I ran into something I was not expecting. If I try to query a spreadsheet that has columns that only have strings (no numbers), it doesn't grab/load the information correctly. It combines all rows into one. After chasing the wrong squirrel for a while, I figured out if I add a column and fill it with numbers, it loads and displays the table fine. Here's a fiddle: http://jsfiddle.net/siobahnv/s5vqg/ Is this a bug? Or did I just miss something in the documentation? -- 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: Querying a Spreadsheet: Not correct when only string values
No need to file that report; I'll forward this conversation to the right folks inside Google. Jon On Fri, May 9, 2014 at 3:53 PM, HRansome sioba...@gmail.com wrote: Woo it's not me! And thank you. I'm more than happy to post the bug report to spreadsheets rather than Visualization API if you could point me in the right direction. Figuring out how to customize the CSS to a control slider bar has been less painful than trying to figure out where to post a bug report. On Friday, May 9, 2014 10:46:15 AM UTC-7, Andrew Gallant wrote: That looks like a bug to me. You can file a bug report on it herehttp://code.google.com/p/google-visualization-api-issues/issues/list, though it's technically a bug with the spreadsheets rather than the Visualization API. On Friday, May 9, 2014 1:28:08 PM UTC-4, HRansome wrote: So I ran into something I was not expecting. If I try to query a spreadsheet that has columns that only have strings (no numbers), it doesn't grab/load the information correctly. It combines all rows into one. After chasing the wrong squirrel for a while, I figured out if I add a column and fill it with numbers, it loads and displays the table fine. Here's a fiddle: http://jsfiddle.net/siobahnv/s5vqg/ Is this a bug? Or did I just miss something in the documentation? -- 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] Re: Querying a Spreadsheet: Not correct when only string values
Well that works too. Thank you! On Friday, May 9, 2014 12:54:56 PM UTC-7, orw...@google.com wrote: No need to file that report; I'll forward this conversation to the right folks inside Google. Jon On Fri, May 9, 2014 at 3:53 PM, HRansome siob...@gmail.com javascript:wrote: Woo it's not me! And thank you. I'm more than happy to post the bug report to spreadsheets rather than Visualization API if you could point me in the right direction. Figuring out how to customize the CSS to a control slider bar has been less painful than trying to figure out where to post a bug report. On Friday, May 9, 2014 10:46:15 AM UTC-7, Andrew Gallant wrote: That looks like a bug to me. You can file a bug report on it herehttp://code.google.com/p/google-visualization-api-issues/issues/list, though it's technically a bug with the spreadsheets rather than the Visualization API. On Friday, May 9, 2014 1:28:08 PM UTC-4, HRansome wrote: So I ran into something I was not expecting. If I try to query a spreadsheet that has columns that only have strings (no numbers), it doesn't grab/load the information correctly. It combines all rows into one. After chasing the wrong squirrel for a while, I figured out if I add a column and fill it with numbers, it loads and displays the table fine. Here's a fiddle: http://jsfiddle.net/siobahnv/s5vqg/ Is this a bug? Or did I just miss something in the documentation? -- 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.comjavascript: . To post to this group, send email to google-visua...@googlegroups.comjavascript: . 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.
