Fermé

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.

Compétences : PHP, JavaScript, MySQL, Charts

Concernant le client :
( 39 commentaires ) Dubois, United States

Nº du projet : #35844952

11 freelances font une offre moyenne de 32 $ pour ce travail

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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(159 Commentaires)
6.2
subinpvasu

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(22 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(14 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(4 Commentaires)
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
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. Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0