Home News Contact Us Forum About Us Demos Products F.A.Q.
ARI Soft









Register   Lost Password?
Featured Demos

ARI Smart Content demo

ARI Quiz demo

WordPress Quiz plugin

WordPress Lightbox plugin







e-mail: info@ari-soft.com
Shopping Cart
You currently have 0 items in your cart.
Show Cart


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.
    more...

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.
    more...


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?
ARI Soft Forum
Joomla components
ARI Data Tables

Perpetual month graph
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Perpetual month graph
#20459
Perpetual month graph 12 Years, 7 Months ago Karma: 0
Hi,

I have date

2010-10-02
2010-11-05
2011-01-17
2011-05-03

etc. etc.

Is it possible to create a graph which shows the 'totals per Month' of the past 12 Months?

This month is October. I want to show a graph from October 2010 till October 2011.

Next month: November 2010 till November 2011 etc.

Is this possible?
diender
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#20492
Re:Perpetual month graph 12 Years, 7 Months ago Karma: 748
Hello,

Is data stored in a CSV file or a database? Could you provide a sample CSV file or SQL dump?

Regards,
ARI Soft
admin
User Online Now Click here to see the profile of this user
The administrator has disabled public write access.
 
#20524
Re:Perpetual month graph 12 Years, 7 Months ago Karma: 0
Is data stored in a CSV file or a database? Could you provide a sample CSV file or SQL dump?

The data is stored in a SQL database. I want to use one field: created. It has this output '2011-10-05 19:55:31'. Every new record get a new timestamp. I want to show in a graph the amount of records created per month.
diender
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#20538
Re:Perpetual month graph 12 Years, 7 Months ago Karma: 748
Try to use the next SQL query:

Code:

SELECT
 *
FROM
 tbl
WHERE
 created > (SELECT CURDATE() - INTERVAL 1 YEAR - INTERVAL (DAYOFMONTH(CURDATE()) - 1) DAY)


Regards,
ARI Soft
admin
User Online Now Click here to see the profile of this user
Last Edit: 2011/10/10 10:38 By admin.
The administrator has disabled public write access.
 
Go to topPage: 1
ARI Soft Forum
Joomla components
ARI Data Tables
Powered by Kunenaget the latest posts directly to your desktop
Useful Links
Products
F.A.Q.
Discount
RSS
Top Products
ARI Data Tables
ARI Sexy Lightbox
ARI Quiz
ARI Stream Quiz - Personal
ARI Smart Content
Help
Forum
F.A.Q.
Home | News | Contact Us | Forum | About Us | Demos | Products | F.A.Q.
ARI Soft
License | Terms and Conditions | Copyright Info | Privacy Policy
 
ARI Soft
Copyright © 2009