ARI Soft - Perpetual month graph

Home

News

Forum

About Us

Demos

Products

F.A.Q.

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

23/11/2024 Black Friday 2024

BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.

more...
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...

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

Welcome, Guest
Please Login or Register. Lost Password?

ARI Soft Forum

Joomla components

ARI Data Tables

Perpetual month graph

(1 viewing) (1) Guest

Page: 1

TOPIC: Perpetual month graph

Forum Tools

#20459

Perpetual month graph 13 Years, 1 Month 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

The administrator has disabled public write access.

#20492

Re:Perpetual month graph 13 Years, 1 Month ago	Karma: 760
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

The administrator has disabled public write access.

#20524

Re:Perpetual month graph 13 Years, 1 Month 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

The administrator has disabled public write access.

#20538

Re:Perpetual month graph 13 Years, 1 Month ago Karma: 760

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

Last Edit: 2011/10/10 10:38 By admin.

The administrator has disabled public write access.

Page: 1

Useful Links