Closed

Google Charts "Column Chart" display of YoY gross sales, by month

Job Description:

I need the HTML/PHP for a Google Column Chart that will display year-over-year gross sales, by month

The mysqli query for the data set is:

==========

SELECT DATE_FORMAT([login to view URL], '%Y') AS Year,

DATE_FORMAT([login to view URL], '%m') AS Month,

SUM(COALESCE(llx_facturedet.total_ht,0)) AS Gross_Sales

FROM llx_facture AS t

LEFT JOIN llx_facturedet ON [login to view URL] = llx_facturedet.fk_facture

GROUP BY DATE_FORMAT([login to view URL], '%Y-%m')

ORDER BY DATE_FORMAT([login to view URL], '%Y-%m') DESC

===========

So each year should be a series, then each of the 12 months displayed with totals for that year.

Skills: PHP, JavaScript, MySQL, Charts

About the Client:
( 39 reviews ) Dubois, United States

Project ID: #35844952

11 freelancers are bidding on average $32 for this job

TechnicalKnight

I am expert in php and html. I can here provide you the code for google chart that will display year-over-year gross sales, by month. Please assign me the task.

$30 USD in 1 day
(159 Reviews)
6.2
subinpvasu

Hi, I'm a PHP Developer with knowledge of Google charts. I can fix your issue. Let's have a chat

$75 USD in 1 day
(22 Reviews)
5.2
whitealien

Hi I did quite a bit of work on google graphs in the last couple of years for a customer working in the finance industry. We also used another graphs framework, highcharts, it's pretty good too. I am confident I can More

$35 USD in 2 days
(14 Reviews)
5.2
corriganleojohn

Hi! I am always ready for you!!! I have read your requirements carefully, I'm ready to start your project now. I have rich experiences in PHP, JS, CSS, MySQL, HTML and so on. As a senior web develper for 7 years in th More

$20 USD in 1 day
(4 Reviews)
2.7
sifergan

Hello. I have read your requirement carefully. I have web development experience over 7 years. I will work full time for this task and finish it on time. I will work seriously. Please contact me for detail. Thank you.

$30 USD in 1 day
(1 Review)
0.0
purnadangal5

Hello. I carefully studied what you asked for. I have almost ten years of web development experience. I'll put forth my full effort to complete this assignment by the deadline. I'll put in considerable effort. For more More

$20 USD in 7 days
(0 Reviews)
0.0
RadoDevelopment

Dear Client! I am ready to start right now. I can help you. I'm confident that I can complete this project according to your desires. I have strong experiences in PHP, React, JavaScript, Typescript, Vue.JS, Angular Js. More

$30 USD in 1 day
(0 Reviews)
0.0