How to solve Date(from sql query) comparison properly for drawing graph in ascending order
10 views
Skip to first unread message
hasan
Sep 2, 2010, 3:02:27 AM9/2/10
to CommCare Volunteer
Hi,
I am fetching a problem to draw the graph(Date in x-axis &
Corresponding value in y-axis using Graphing/models.py, views.py) in
ascending order with corresponding value.
Suppose My DB data like this...
Date: Increase-Value:
2009-08-03 15
2009-11-10 4
2010-03-30 6
2010-06-20 3
2010-08-10 2
2010-09-01 5
when I want to plot a graph according to the date & increase-value. It
compare the month & day only such as 20-03-30 takes as the smallest
date because it's month (03) is the smallest. And point it's value(6)
as the starting point. But it will be 2009-08-03 as the smallest date
& starting point will be 15.
How to solve this problem.
Can any one help me please.....
I am fetching a problem to draw the graph(Date in x-axis &
Corresponding value in y-axis using Graphing/models.py, views.py) in
ascending order with corresponding value.
Suppose My DB data like this...
Date: Increase-Value:
2009-08-03 15
2009-11-10 4
2010-03-30 6
2010-06-20 3
2010-08-10 2
2010-09-01 5
when I want to plot a graph according to the date & increase-value. It
compare the month & day only such as 20-03-30 takes as the smallest
date because it's month (03) is the smallest. And point it's value(6)
as the starting point. But it will be 2009-08-03 as the smallest date
& starting point will be 15.
How to solve this problem.
Can any one help me please.....
Reply all
Reply to author
Forward
0 new messages