Tech
Forums
Jobs
Books
Events
Videos
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
0
Answer
Help me in a graph
Bharat Bhushan
13y
1.5k
1
Reply
have two tables
1. tb_data with the following column
see this link
http://www.bd.bloodbankbdcnsr.org/tb_data.jpg
2. tb_strek with the following column
see this link
http://www.bd.bloodbankbdcnsr.org/streak.jpg
I need the following Chart
see this link
http://www.bd.bloodbankbdcnsr.org/chart_.jpg
when inside the column tb_strek there is a streal value >= 10 of any topic of
a user then i need the date when he completed the chapter or topic.
see the detail of the user inside the tb_data
http://www.bd.bloodbankbdcnsr.org/tb_data.jpg
and if the user not work on any date . this date is not available inside the
database.then i want to show that there is no work .you can see the straight
line inside the graph .
http://www.bd.bloodbankbdcnsr.org/chart_.jpg.
this image show that the 1st chapter completed by the user at first day and
second chapter is completed by the user at 8th day and so on.
Please help me. i need sql query and help to create a graph
can anybody help me.....
Thankx...
Post
Reset
Cancel
Answers (
0
)
Next Recommended Forum
Cascading dropdown
Run Web Appliation exe without iis server.