Re: [visualization-api] Re: Overlap issue

2015-07-27 Thread 'Sergey Grabkovsky' via Google Visualization API
Hi codefreak, I'm not sure what you mean. You're already using an external library ( angular-google-chart https://github.com/angular-google-chart/angular-google-chart); this is a third-party library to add angular directives for Google Charts (which is also an external library). In theory, you

[visualization-api] Re: How to get local JSON file into html file

2015-07-27 Thread Daniel Buttery
You absolutely can! On the download page theres a Mac installer that'll sort it all for you. On Monday, 27 July 2015 16:29:37 UTC+1, Tim Steele wrote: I think that is a great suggestion, however I am on a MAC, so I don't believe I can use apache? On Monday, July 27, 2015 at 2:48:22 AM

[visualization-api] Re: How to get local JSON file into html file

2015-07-27 Thread Tim Steele
I think that is a great suggestion, however I am on a MAC, so I don't believe I can use apache? On Monday, July 27, 2015 at 2:48:22 AM UTC-7, Daniel Buttery wrote: I'd recommend using something like XAMPP on your machine ( https://www.apachefriends.org/index.html). Its a very quick, easy way

[visualization-api] How to Show Data Point values on google Line Chart

2015-07-27 Thread skg
Hi, I am able to show data points on one Line, but in second line data points are not showing, Below is the code. Example Key1 Values : 40 , 29 , 51, 53 Key2 Values : 0 ,15 , 2 ,60 Key1 Values are showing on Data Points, but key2 are not showing function

[visualization-api] one-point annotation, but avoid the extra null column in the dataset?

2015-07-27 Thread George Michaelson
I have one point on a timeline (the new SVG one, not the old flash one) which I want to annotate. (we changed data collection method at a specific date and I'd like to signpost the knee in the graph as 'we know this') The worked examples in the google chart api reference all seem to incur the

Re: [visualization-api] dir=rtl in the HTML tag produces a wide page bug

2015-07-27 Thread 'Sergey Grabkovsky' via Google Visualization API
Hi, Unfortunately, we currently don't have any way to fix this. This is a known bug. Here is an extremely hacky (and probably not very dependable) workaround: http://jsfiddle.net/a1qq3qfa/ On Sun, Jul 26, 2015 at 2:57 AM KQJ khalidaljaa...@gmail.com wrote: Hi Adding this option to the HTML

[visualization-api] charts displaying compressed on one side

2015-07-27 Thread SmarterHash Channel
we've been using good charts for about 6 months now in our app and about 2 weeks ago a user reporting that his charts were displaying compressed in an area that was about 30 to 40% of the window width. I could not reproduce the problem but low and behold today - my charts also started

[visualization-api] Re: Polynomial trendlines not working when x-axis is datetime

2015-07-27 Thread ianf
Since my original post, I've tried importing the datetimes with raw millisecond values and parameters in the Date constructor (*new Date(1436816502123)* and *new Date(2015,6,13,19,41,42)* respectively) but the polynomial trendline still shows a straight line. I also tried creating the dataset

[visualization-api] dynamically add trendline

2015-07-27 Thread Kostas Poulakidas
Hello, I have a list of the options the user want to represent in a LineChart. He selects the options and the he draw the Chart. Representing the data is ok. And the result is smh like this https://jsfiddle.net/h7k273yb/ My problem is that I can not dynamically add trendiness . *I tried

Re: [visualization-api] dynamically add trendline

2015-07-27 Thread Kostas Poulakidas
Hello Sergey, and thanks for the quick response. You got right what I am trying to do but the Chart doesn't show any trendlines. In your code you don't specify that the loop is referring to the trendlines. Maybe this is the reason? Τη Δευτέρα, 27 Ιουλίου 2015 - 12:53:53 μ.μ. UTC-7, ο

Re: [visualization-api] charts displaying compressed on one side

2015-07-27 Thread 'Daniel LaLiberte' via Google Visualization API
We can't tell much just from the image, but since nothing has changed on the Google Charts side, I would guess there is a change in your html that causes this. If your chart gets its width from the container, then you have to make sure the container is the size you expect. Try setting the width

Re: [visualization-api] charts displaying compressed on one side

2015-07-27 Thread SmarterHash Channel
thanks - the weird part is that we have no touched the code in months - have not even gone near it and all of a sudden people starts started getting compressed - I got reports but could not reproduce it - then this morning I brought up a chart and it was compressed. I wonder if I could share

Re: [visualization-api] dynamically add trendline

2015-07-27 Thread 'Sergey Grabkovsky' via Google Visualization API
Hi Kostas, You can absolutely dynamically add trendlines! However, the chart doesn't automatically detect changes in the options or the DataTable (JavaScript makes it kind of difficult to monitor object properties), so you have to explicitly redraw the chart with the new options. I'm also not

Re: [visualization-api] dynamically add trendline

2015-07-27 Thread 'Sergey Grabkovsky' via Google Visualization API
Oh I'm sorry. I was too hasty in sending you the code. I actually meant this: options.trendlines = {}; for (var i = 0; i NUMBER_OF_TRENDLINES; i++) { options.trendlines[i] = { color: 'black', lineWidth: 6 } } On Mon, Jul 27, 2015 at 4:10 PM Kostas Poulakidas poulakid...@gmail.com

Re: [visualization-api] dynamically add trendline

2015-07-27 Thread Kostas Poulakidas
Great it works like a charm! Also do you know if I can have *one* trendine for all the data series. Just calculating the average is not a option as I don't always have non-null values in both series, and I use interpolating nulls. Please check the thread here.

Re: [visualization-api] dynamically add trendline

2015-07-27 Thread Kostas Poulakidas
I am not sure what I should do in order to add more columns eg data.addColumn('number', 'Mouse'); what changes should I do? Τη Δευτέρα, 27 Ιουλίου 2015 - 2:31:35 μ.μ. UTC-7, ο χρήστης Sergey έγραψε: Oops! I just realized that my solution requires the data to be evenly spaced (it doesn't

[visualization-api] vAxis - is there a way to add checkboxes to labels?

2015-07-27 Thread GinoDivx
Hi, I have a requirement to show one series of data on a bar chart. 2nd requirement is to have an ability to turn on/off parts of the chart (and/or table displayed next to it), if a label is clicked. While I can have a click event and get the label value, it would be nicer to have a checkbox

Re: [visualization-api] dynamically add trendline

2015-07-27 Thread 'Sergey Grabkovsky' via Google Visualization API
No problem. It was a fun little problem. I think I included enough comments for someone to make sense of it. On Mon, Jul 27, 2015 at 5:24 PM Kostas Poulakidas poulakid...@gmail.com wrote: WoW! You are fast! Give me some time to understand what you are doing and I will come back to you.

Re: [visualization-api] dynamically add trendline

2015-07-27 Thread 'Sergey Grabkovsky' via Google Visualization API
You just need to add the column index to the series array. That should be enough On Mon, Jul 27, 2015 at 5:41 PM Kostas Poulakidas poulakid...@gmail.com wrote: I am not sure what I should do in order to add more columns eg data.addColumn('number', 'Mouse'); what changes should I do? Τη

Re: [visualization-api] dynamically add trendline

2015-07-27 Thread 'Sergey Grabkovsky' via Google Visualization API
Dan is correct, there is no way to compute a trendline for a combination of series. You'll have to compute the average or the sum. You say that there's ambiguity when one series has a null value and another is non-null and you are correct, which means that there would be ambiguity whether we

Re: [visualization-api] dynamically add trendline

2015-07-27 Thread Kostas Poulakidas
WoW! You are fast! Give me some time to understand what you are doing and I will come back to you. Thanks again. Τη Δευτέρα, 27 Ιουλίου 2015 - 1:54:55 μ.μ. UTC-7, ο χρήστης Sergey έγραψε: Dan is correct, there is no way to compute a trendline for a combination of series. You'll have

Re: [visualization-api] dynamically add trendline

2015-07-27 Thread 'Sergey Grabkovsky' via Google Visualization API
Oops! I just realized that my solution requires the data to be evenly spaced (it doesn't look at the domain values at all). Just wanted to make you aware. On Mon, Jul 27, 2015 at 5:26 PM Sergey Grabkovsky gra...@google.com wrote: No problem. It was a fun little problem. I think I included enough

Re: [visualization-api] dynamically add trendline

2015-07-27 Thread Kostas Poulakidas
To change this var series = [1, 2]; // an array of all the series columns. into this var series = [1, 2, 3]; // an array of all the series columns. here is an example but it doesn't seem to work :-( https://jsfiddle.net/a2amazpc/ Τη Δευτέρα, 27 Ιουλίου 2015 - 2:51:39 μ.μ. UTC-7, ο

Re: [visualization-api] dynamically add trendline

2015-07-27 Thread 'Sergey Grabkovsky' via Google Visualization API
With the exception of the trendline showing up for the wrong series, that example fully worked. Here is a version where that bug is fixed: https://jsfiddle.net/a2amazpc/1/ Note that even that version still has the issue where it doesn't take the domain values into account, so your data has to be

Re: [visualization-api] dynamically add trendline

2015-07-27 Thread 'Sergey Grabkovsky' via Google Visualization API
To answer your questions: - The trendline is showing up, it's the green line. It's not in the legend because trendlines are omitted from the legend by default. Set the visibileInLegend option on the trendline to true in order to change that. - Oh, I set the focusTarget to be 'category' so I could

Re: [visualization-api] dynamically add trendline

2015-07-27 Thread 'Sergey Grabkovsky' via Google Visualization API
Oh, and here's a version that scales based on domain values as well: https://jsfiddle.net/a2amazpc/2/ Good luck! Hope you can read my code =) On Mon, Jul 27, 2015 at 6:13 PM Sergey Grabkovsky gra...@google.com wrote: With the exception of the trendline showing up for the wrong series, that

Re: [visualization-api] dynamically add trendline

2015-07-27 Thread Kostas Poulakidas
Sorry for sending again, but - why the Trendline isn't showing - why the tooltips are behaving so weirdly? Τη Δευτέρα, 27 Ιουλίου 2015 - 3:13:46 μ.μ. UTC-7, ο χρήστης Sergey έγραψε: With the exception of the trendline showing up for the wrong series, that example fully worked. Here is a

Re: [visualization-api] Re: Overlap issue

2015-07-27 Thread codefreak18
hi, Sergery How can i solve overlap problem in Angular google chart (ng.google.chart.js). i don't want to use external library for it. On Sunday, July 26, 2015 at 4:51:37 PM UTC+5:30, codef...@gmail.com wrote: Hi Sergey thanks for help, How can i solve overlap problem in Angular google

[visualization-api] Google Spreadsheet/form Query function

2015-07-27 Thread Niko Chen
I would like to pull out some data from my form response sheet to a new sheet. Here are some data that is gathered in the form. - Income/Expenses - Total Amount - Description - Date The data i need to gather to appear on the new sheet is Income for a specific month. But i am not sure how do i

[visualization-api] Re: How to get local JSON file into html file

2015-07-27 Thread Daniel Buttery
I'd recommend using something like XAMPP on your machine (https://www.apachefriends.org/index.html). Its a very quick, easy way to spin up a web server on your PC so you can edit and code locally yet still view the results in a browser over HTTP. On Monday, 27 July 2015 04:30:52 UTC+1, Tim