Perfect mate, that should do the job now!
Thanks a lot
On Tuesday, August 28, 2012 2:38:22 PM UTC-4, asgallant wrote:
>
> Change the vAxis.format option depending on whether you are drawing one or
> more columns, and in the conversion, return an object {v: value, f:
> 'formatted value'}, like this: http://jsfiddle.net/asgallant/EVQP2/6/
>
> On Tuesday, August 28, 2012 2:13:00 PM UTC-4, kasimir wrote:
>>
>> Thats perfect, you are a great help! Now I only have one last question
>> regarding a cosmetic issue and I already tried around a little but I cannot
>> find a solution.
>>
>> Is there a way that when the chart is in "conversion" mode, the values
>> can be shown with the prefix " %" and the Y-Axis values are shown with "%"
>> sign behind the values? The numbers are already calculated how I want them,
>> but I'm just missing the percentage symbol.
>> When the chart is in "no-conversion" mode (just showing column A), the
>> values should be shown as is with no prefix or percentage sign.
>>
>> Thanks a bunch for helping me out
>>
>> On Tuesday, August 28, 2012 2:00:27 AM UTC-4, asgallant wrote:
>>>
>>> Set the selectedValues parameter of the initState variable to an empty
>>> array:
>>>
>>> var initState = {
>>> selectedValues: []
>>> };
>>>
>>> On Monday, August 27, 2012 10:49:47 PM UTC-4, kasimir wrote:
>>>>
>>>> Only little detail that I'm missing now is, what do I have to change
>>>> that at startup only the default Column A is shown and no other column. I
>>>> Tried to remove the initState, but that messes up the graph...
>>>>
>>>> On Monday, August 27, 2012 10:39:50 PM UTC-4, kasimir wrote:
>>>>>
>>>>> Let me take that back ... everything works perfectly, you helped me
>>>>> out a lot and basically created the perfect compare tool!
>>>>>
>>>>> Thanks a bunch!
>>>>>
>>>>> On Monday, August 27, 2012 10:12:02 PM UTC-4, kasimir wrote:
>>>>>>
>>>>>> Quite close, thanks first of all ... Only thing missing now is, I
>>>>>> want it to start with just the A Column (the areachart) graphed as
>>>>>> default
>>>>>> and with no conversion at that point. As soon as the user selects
>>>>>> another
>>>>>> Column (or more than 1), than the data should be converted.
>>>>>>
>>>>>> So basically something like:
>>>>>> - if (any column selected, except column A)
>>>>>> => data conversion true
>>>>>> - else
>>>>>> => data conversion false
>>>>>>
>>>>>> Sorry, I wouldn't know how to explain it better, but this should do
>>>>>> it :)
>>>>>>
>>>>>> Much appreciated
>>>>>>
>>>>>> On Monday, August 27, 2012 6:26:15 PM UTC-4, asgallant wrote:
>>>>>>>
>>>>>>> Let me see if I have this straight: for the first part, you want to
>>>>>>> have one column that always gets graphed and that users can't turn off,
>>>>>>> and
>>>>>>> if this is the only column, you want it graphed as is without any
>>>>>>> conversion - correct? This is doable. You're second request is also
>>>>>>> doable, we just have to change to using a ComboChart and define the
>>>>>>> types
>>>>>>> for each series. See both in action:
>>>>>>> http://jsfiddle.net/asgallant/EVQP2/5/
>>>>>>>
>>>>>>> On Monday, August 27, 2012 5:35:46 PM UTC-4, kasimir wrote:
>>>>>>>>
>>>>>>>> Big thanks! After fiddling around and getting familiar with the
>>>>>>>> code I was able to adjust your solution to my issue and it works
>>>>>>>> great,
>>>>>>>> just needs some fine-tuning.
>>>>>>>>
>>>>>>>> Now I only have 2 questions and hope you could help me out with it
>>>>>>>> based on your solution in the other thread.
>>>>>>>> Question 1 (High priority): At this moment all the data gets
>>>>>>>> recalculated to compare it against each other from the get go. Is
>>>>>>>> there a
>>>>>>>> way that, when I set the initState to just one value (in my case
>>>>>>>> Column A)
>>>>>>>> that it just shows the original data without calculating and as soon
>>>>>>>> as
>>>>>>>> someone adds at least one Column from the Category Filter, the data
>>>>>>>> will be
>>>>>>>> calculated so that they can be compared relative to each other.
>>>>>>>> => Follow up: Is there a way to not show Column A in the Category
>>>>>>>> Filter, since I always want it visible as default data.
>>>>>>>>
>>>>>>>> Question 2 (Low priority): Is it possible that Column A (by default
>>>>>>>> always visible) is an AreaChart and the other Colums (B, C, D, E
>>>>>>>> etc...)
>>>>>>>> when selected will be a LineChart?
>>>>>>>>
>>>>>>>> Would be great if you could help me out with this and to keep it
>>>>>>>> simple lets use http://jsfiddle.net/asgallant/EVQP2/ as basis and
>>>>>>>> then I will be able to adapt the solution to my chart.
>>>>>>>>
>>>>>>>> Thanks a bunch!
>>>>>>>>
>>>>>>>> On Friday, August 17, 2012 2:21:12 PM UTC-4, asgallant wrote:
>>>>>>>>>
>>>>>>>>> I helped someone else do something similar recently (see this
>>>>>>>>> thread<https://groups.google.com/forum/#!msg/google-visualization-api/oaVQYRmTWKg/cBARJyn5MXYJ>).
>>>>>>>>>
>>>>>>>>> That example is a bit more complicated than what you are asking here
>>>>>>>>> (they
>>>>>>>>> also wanted to be able to add and remove columns from the chart using
>>>>>>>>> CategoryFilter controls), but should give you a good idea of what’s
>>>>>>>>> possible.
>>>>>>>>>
>>>>>>>>> On Friday, August 17, 2012 1:32:13 PM UTC-4, kasimir wrote:
>>>>>>>>>>
>>>>>>>>>> Thanks for the reply,
>>>>>>>>>> I would like to compare the data on a relative basis (%), similar
>>>>>>>>>> like two (or more) stocks can be compared in Google Finance in a
>>>>>>>>>> specified
>>>>>>>>>> timeframe where at t=0 both data-value are 0% and from there on the
>>>>>>>>>> performance can be compared.
>>>>>>>>>> Here is an example from Google Finance where the stocks of Google
>>>>>>>>>> (in red) is compared against Apple (in blue) in a time-frame of 1
>>>>>>>>>> month:
>>>>>>>>>>
>>>>>>>>>> http://www.google.com/finance?chdnp=1&chdd=1&chds=1&chdv=1&chvs=Linear&chdeh=0&chfdeh=0&chdet=1345233600000&chddm=8993&chls=IntervalBasedLine&cmpto=NASDAQ:GOOG&cmptdms=0&q=NASDAQ:AAPL&ntsp=0
>>>>>>>>>>
>>>>>>>>>> Now I would like to use my own data and compare that to another
>>>>>>>>>> dataset or even compare my data against a stock.
>>>>>>>>>>
>>>>>>>>>> I'm asking because I have written a piece of software in PHP
>>>>>>>>>> which tracks performance data of companies and clients which is then
>>>>>>>>>> visualized in a google line chart, but it would be great to compare
>>>>>>>>>> the
>>>>>>>>>> data against each other or against other market relevant data (like
>>>>>>>>>> stocks
>>>>>>>>>> or market indexes) in a relative way.
>>>>>>>>>>
>>>>>>>>>> Hope I'm not the only one who can use this? :)
>>>>>>>>>>
>>>>>>>>>> On Thursday, August 16, 2012 11:29:50 PM UTC-4, asgallant wrote:
>>>>>>>>>>>
>>>>>>>>>>> What you want is most likely possible, but it depends on exactly
>>>>>>>>>>> how you want to compare the data. The chart's won't do everything
>>>>>>>>>>> for you
>>>>>>>>>>> in many cases, but you should be able to write javascript to format
>>>>>>>>>>> the
>>>>>>>>>>> data however you need for a given method of comparison.
>>>>>>>>>>>
>>>>>>>>>>> On Thursday, August 16, 2012 8:19:54 PM UTC-4, kasimir wrote:
>>>>>>>>>>>>
>>>>>>>>>>>> I have looked around but couldn't find an answer.
>>>>>>>>>>>>
>>>>>>>>>>>> I use a line-chart which gets its data from an XML file
>>>>>>>>>>>> (updated daily with date and a value per entry) and this works
>>>>>>>>>>>> great.
>>>>>>>>>>>> Now my question, is there a way two data sources can be
>>>>>>>>>>>> compared against each other on a relative basis, kinda like how
>>>>>>>>>>>> its done at
>>>>>>>>>>>> Google Finance when you compare one stock against an other, where
>>>>>>>>>>>> the chart
>>>>>>>>>>>> turns relative and compares the performance?
>>>>>>>>>>>>
>>>>>>>>>>>> Also is there a way that my data source can be compared with
>>>>>>>>>>>> the Dow Jones (for example) on a relative basis?
>>>>>>>>>>>
>>>>>>>>>>>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/google-visualization-api/-/QXCgyFUbPZsJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.
