Hi, I need a *solution *for using graph for *data comparison*.
Suppose I have data like this: [ ["Quarter","Moth","Last Year","Forecast","This Year"], ["Q1","M1-January",2.11,1.82,1.69], ["Q1","M2-February",0.42,0.65,0.72], ["Q1","M3-March",0.4,0.61,0.64], ["Q2","M1-April",2.11,1.82,1.69], ["Q2","M2-May",0.42,0.65,0.72], ["Q2","M3-June",0.4,0.61,0.64] ["Q3","M1... ] I need to show a data comparison graph somewhat like the first half of this graph https://plot.ly/~etpinard/195/montreal-vancouver-1981-2010-climates/ I.e., I want that on the data comparison graph, the first data column ("Last Year") is the baseline, whatever the other columns, ("Forecast","Revised Forecast","This Year",etc) will be a percentage to the baseline, growing upwards if greater than the baseline, or downwards if less than the baseline. Is this possible to do it in Google Chart? >From https://google-developers.appspot.com/chart/interactive/docs/gallery/columnchart It seems that using a formatter <https://developers.google.com/chart/interactive/docs/reference#formatters> wrapper function like this: function getValueAt(column, dataTable, row) { return dataTable....(row, column); } Then call it with calc: getValueAt.bind(undefined, 1) should be the solution. However, As I don't know either Google Chart or javascript, so your detailed help is appreciated. Everything is up for discussion for a better solution: - the first column ("Quarter"), I hope to retain it in the data array because I want to do filtering on that field once I overcome this first step. - the data are pull from database, so data manipulation is possible if necessary (e.g., if pulling directly as percentage when desired), however - I do need the tooltip/annotation to show the actual value when mouse-over. The ideal annotation is in the format: Q1 M2-February 0.65/0.42=1.55 Thanks for your help! -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
