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/-/7g8n2pjDssMJ.
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.
