Generating Column chart using Google Visualization API(google chart)

71 views
Skip to first unread message

Prabu Uthirapathi

unread,
Dec 1, 2013, 7:16:40 AM12/1/13
to google-visua...@googlegroups.com
I would like to generate the report for the top 3 selling products..for the last 3 days. X-Axis should be dates(last 3 days). Y axis ..number of units sold. we need show the product names of the top selling products in the chart. can you please tell me how to do it in google chart or any other chart? I Like to use column chart.

asgallant

unread,
Dec 1, 2013, 7:40:38 PM12/1/13
to google-visua...@googlegroups.com

Prabu Uthirapathi

unread,
Dec 1, 2013, 9:31:13 PM12/1/13
to google-visua...@googlegroups.com
Thanks for quick reply. product names vary..everyday. product names wont be constant. For example: top selling product of the yesterday wont be in the top 3 in the next day. can you please show that in the graph.

"My life is my message" - Gandhi


--
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/lq23ifeV4Sc/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-visualizati...@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/groups/opt_out.

asgallant

unread,
Dec 2, 2013, 12:14:29 AM12/2/13
to google-visua...@googlegroups.com
Change the text in the table: http://jsfiddle.net/asgallant/8L5sa/2/


On Sunday, December 1, 2013 9:31:13 PM UTC-5, Prabu Uthirapathi wrote:
Thanks for quick reply. product names vary..everyday. product names wont be constant. For example: top selling product of the yesterday wont be in the top 3 in the next day. can you please show that in the graph.

"My life is my message" - Gandhi


On Mon, Dec 2, 2013 at 6:10 AM, asgallant <drew_g...@abtassoc.com> wrote:
Here's an example: http://jsfiddle.net/asgallant/8L5sa/


On Sunday, December 1, 2013 7:16:40 AM UTC-5, Prabu Uthirapathi wrote:
I would like to generate the report for the top 3 selling products..for the last 3 days. X-Axis should be dates(last 3 days). Y axis ..number of units sold. we need show the product names of the top selling products in the chart. can you please tell me how to do it in google chart or any other chart? I Like to use column chart.

--
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/lq23ifeV4Sc/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-visualization-api+unsub...@googlegroups.com.

Prabu Uthirapathi

unread,
Dec 2, 2013, 12:22:47 AM12/2/13
to google-visua...@googlegroups.com
Thanks again. when I did the mouse over to the column, it doesnt show the product name..it shows the "highest sales" instead. But I want the product name to be shown when I do the mouse over.



"My life is my message" - Gandhi


To unsubscribe from this group and all its topics, send an email to google-visualizati...@googlegroups.com.

asgallant

unread,
Dec 2, 2013, 1:08:47 AM12/2/13
to google-visua...@googlegroups.com
Normally, the tooltips get their labels from the column labels ("Highest sales" etc).  If you want to override that, you have to use custom tooltips.  Here's one example: http://jsfiddle.net/asgallant/8L5sa/3/


On Monday, December 2, 2013 12:22:47 AM UTC-5, Prabu Uthirapathi wrote:
Thanks again. when I did the mouse over to the column, it doesnt show the product name..it shows the "highest sales" instead. But I want the product name to be shown when I do the mouse over.



"My life is my message" - Gandhi


On Mon, Dec 2, 2013 at 10:44 AM, asgallant <drew_g...@abtassoc.com> wrote:
Change the text in the table: http://jsfiddle.net/asgallant/8L5sa/2/


On Sunday, December 1, 2013 9:31:13 PM UTC-5, Prabu Uthirapathi wrote:
Thanks for quick reply. product names vary..everyday. product names wont be constant. For example: top selling product of the yesterday wont be in the top 3 in the next day. can you please show that in the graph.

"My life is my message" - Gandhi


On Mon, Dec 2, 2013 at 6:10 AM, asgallant <drew_g...@abtassoc.com> wrote:
Here's an example: http://jsfiddle.net/asgallant/8L5sa/


On Sunday, December 1, 2013 7:16:40 AM UTC-5, Prabu Uthirapathi wrote:
I would like to generate the report for the top 3 selling products..for the last 3 days. X-Axis should be dates(last 3 days). Y axis ..number of units sold. we need show the product names of the top selling products in the chart. can you please tell me how to do it in google chart or any other chart? I Like to use column chart.

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

Prabu Uthirapathi

unread,
Dec 2, 2013, 12:05:40 PM12/2/13
to google-visua...@googlegroups.com
Ok. Thanks. I would be populating the datatable from the database(in servlet).    will I be able to use the following code(or anything equivalent) in java ..

         data.addColumn({type: 'string', role: 'annotation'});










"My life is my message" - Gandhi


To unsubscribe from this group and all its topics, send an email to google-visualizati...@googlegroups.com.

asgallant

unread,
Dec 2, 2013, 12:46:01 PM12/2/13
to google-visua...@googlegroups.com
Check the documentation for whatever java library you are using to implement this.  The library should support column roles.

Prabu Uthirapathi

unread,
Dec 10, 2013, 2:20:49 AM12/10/13
to google-visua...@googlegroups.com
Thanks. I am able to generate the chart from db data. I am having one issue..tooltip works fine.But It doesnt show the name of the product on top the column. any thoughts?

"My life is my message" - Gandhi


To unsubscribe from this group and all its topics, send an email to google-visualizati...@googlegroups.com.

Prabu Uthirapathi

unread,
Dec 10, 2013, 7:50:04 AM12/10/13
to google-visua...@googlegroups.com
sometimes it shows the labels on the columns..sometimes it doesnt. I am not sure what is causing this..

"My life is my message" - Gandhi


asgallant

unread,
Dec 10, 2013, 9:59:57 AM12/10/13
to google-visua...@googlegroups.com
Do you have a public-facing page I can test?
Reply all
Reply to author
Forward
0 new messages