Discussion Forums  >  Plugins, Customizing, Source Code

Replies: 5    Views: 55

James R
Aspiring developer
Profile
Posts: 31
Reg: Aug 15, 2012
sydney
3,310
08/21/12 04:56 AM (11 years ago)

Graphs

Hey Im just wondering how hard it is to have graphs and charts displayed in an app from a database. The process would be: 1. Admin enters in scores 2. Code creates calculation (ie. Average) of the scores (the one just entered and all previous scores entered) 3. User can open app to see a refreshed chart/graph of the 'average' chart The look would idealy be nice smooth charts. Im just wondering if its plausible and how hard on a 'moderate' programmer's level of experience. Any quick info would be great
 
Ledbelly2142
Aspiring developer
Profile
Posts: 80
Reg: Aug 04, 2012
Reno
6,750
like
08/21/12 07:37 AM (11 years ago)
I'm very interested in this topic as well. I found a great ( my opinion) MySQL cloud db servive called Xeround they are at Xeround.com. I am using them for a data logging project monitoring near real time energy (building) use for a cloud based monitoring system. Would be really cool to be able to chart that in an app. Anyone making a plugin for this on the new plugin marketplace? -Led
 
GoNorthWest
buzztouch Evangelist
Profile
Posts: 8197
Reg: Jun 24, 2011
Oro Valley, AZ
1,000,000
like
08/21/12 09:13 AM (11 years ago)
Hi, If you are grabbing the data from a database that's on the network, there are tons of PHP scripts out there that can do graphing for you. You'd just need to call those scripts from a Custom URL screen, or create an HTML screen that has the form in it you mention, then call some PHP script somewhere to do the graphing for you. Check this link out for some ideas: http://jpgraph.net/ Mark
 
Ledbelly2142
Aspiring developer
Profile
Posts: 80
Reg: Aug 04, 2012
Reno
6,750
like
08/21/12 10:34 AM (11 years ago)
James, I'm sorry, didn't intend to hijack your thread. It's just a really good topic, IMHO. Mark, Thank you, excellent suggestion, I will try. looks interesting, JPgraph not bad for $100 single server lic (pro version). I will look into it. The support on a purchased product like this alone would save me the time. Here is another, open source: http://dygraphs.com/ Graphic look good for charts, no cool dials, pie charts and odometers like JPgraph Pro. My challenge is to enable each user to see their own data charts... Not sure how to make a sign in component that connects the the right page with that users charting (data). Separate non BuzzTouch related issue... I have a php package from MysqlReports "smart charts" ($48) I purchased and (easily) implemented (from http://mysqlreports.com/ very poor support), just can't get it to work with the time format being logged to my xeround MySQL cloud db yet. Too strict on date formats to plot a xy graph with time. Time is critical to show logging data, loggers are not easy to format time output. -Led
 
James R
Aspiring developer
Profile
Posts: 31
Reg: Aug 15, 2012
sydney
3,310
like
08/21/12 06:20 PM (11 years ago)
Mark - Awesome! that jpgraph site looks the goods! Led - Ha no worries it was an open discussion! Im just glad people were interested. Your point on enabling each user to see their own data charts is something I too am interested in James
 
Ledbelly2142
Aspiring developer
Profile
Posts: 80
Reg: Aug 04, 2012
Reno
6,750
like
08/30/12 09:11 PM (11 years ago)
Also found this one scrounging around for libraries... looks interesting: http://www.jfree.org/jfreechart/ Looks like the guide is $65, but comes with lots of demo java code. Not made for Android... not sure what it would take to migrate it. Perhaps the makings of a sweet chart plugin. -Led
 

Login + Screen Name Required to Post

pointerLogin to participate so you can start earning points. Once you're logged in (and have a screen name entered in your profile), you can subscribe to topics, follow users, and start learning how to make apps like the pros.