Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 18/11/2017 Black Friday is coming

    Don't wait BLACK FRIDAY, use FRIDAY17 coupon code to get 35% discount for all our extensions right now.

  • 05/09/2017 BIG Autumn SALE

    Use AUTUMN17 coupon code to buy our WordPress or Joomla! extensions with 25% discount. Hurry up! The offer is valid till 11 September.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

[SOLVED] Help, stuck on a basic SQL query
(1 viewing) (1) Guest
Go to bottomPage: 12
TOPIC: [SOLVED] Help, stuck on a basic SQL query
#58433
[SOLVED] Help, stuck on a basic SQL query 1 Year, 4 Months ago Karma: 0
Hello.
Can you please point me to some documentation on how to use this plugin?
I bought it to use it almost exclusively for MySQL, and I can't seem to get any heads or tails on how to use it.
This is what I get as a graph:
https://s11.postimg.org/cuh266tdb/Capture.jpg[/img]

I used this query with another free plugin (plotalot) and it worked the way it was supposed to:
Code:

SELECT  
CONCAT(year(calendar.datefield),'-', LPAD(month(calendar.datefield), 2, '0')) AS ymonth,
  IFNULL(count(con_inizio_contratto),0) AS assunti,
  year(calendar.datefield) AS anno,
        month(calendar.datefield) AS mese,
       
        IFNULL(count(con_licenziamento_data),0) AS licenziati
FROM datipersonali RIGHT JOIN calendar ON (DATE(datipersonali.con_inizio_contratto) = calendar.datefield)
WHERE (calendar.datefield BETWEEN 
  (SELECT MIN(DATE(datipersonali.con_inizio_contratto)) FROM datipersonali) 
  AND 
  (SELECT MAX(DATE(datipersonali.con_inizio_contratto)) FROM datipersonali))
GROUP BY year(calendar.datefield), month(calendar.datefield), ymonth



This is what I am supposed to get:
https://s21.postimg.org/8w0uk5tsj/Capture2.jpg[/img]

Please help me!
Last Edit: 2016/09/08 04:10 By vladimir84.
The administrator has disabled public write access.
 
#58434
Re:Help, stuck on a basic SQL query 1 Year, 4 Months ago Karma: 672
Hello,

Set "Choose source type -> SQL -> Revert data" parameter to "Yes".

Regards,
ARI Soft
The administrator has disabled public write access.
 
#58435
Re:Help, stuck on a basic SQL query 1 Year, 4 Months ago Karma: 0
Thank you for the quick reply. Unfortunately, now it gives me this:

It doesn't hide the year and month column (in spite of the fact it was selected as hidden here:), and I have to have them in the query in order to sort the data.

Please tell me how to fix it.
The administrator has disabled public write access.
 
#58436
Re:Help, stuck on a basic SQL query 1 Year, 4 Months ago Karma: 672
Could you provide a link to a page with the chart?

Regards,
ARI Soft
The administrator has disabled public write access.
 
#58437
Re:Help, stuck on a basic SQL query 1 Year, 4 Months ago Karma: 0
unfortunately no, it is inside the LAN. But I did save the whole webpage, and I am attaching it here:
File Attachment:
File Name: Desktop-34e43c7118541f4995ce42d1656fd416.zip
File Size: 518439
The administrator has disabled public write access.
 
#58438
Re:Help, stuck on a basic SQL query 1 Year, 4 Months ago Karma: 0
Last Edit: 2016/09/08 08:57 By vladimir84.
The administrator has disabled public write access.
 
Go to topPage: 12