On Sun, Jun 12, 2011 at 1:14 AM, Ammar Yasir ammaryasir.88@gmail.comwrote:
On Fri, Jun 10, 2011 at 6:12 PM, Marc Delisle marc@infomarc.info wrote:
Ammar Yasir a écrit :
Hi,
1. Let's say I choose film_actor, activate actor_id and film_id and enter 1 as the actor id. When I get the results, I no longer see the value I entered in the dialog. But this scenario gives me a notice:I fixed this issue. The notice comes if you do not select a label, I added a default to it so the notice should not come now.
2. What should I enter as data label to have meaningful results?Please
give an example.Actually, we had to show a label for each data point. So for example in 'film' table or 'actor' table 'name' could be a label for points. I haven't implemented showing the label yet, the selection just stores the label for each point internally. I thought showing the label for now (without the zoom feature) would make the plot very difficult to understand.
3. Did you find a table (in sakila) for which choosing two columnsand
generating a plot would make me recognize some kind of trend in the data? As an example, on a copy of the film table I did update film_copy set length = length*3 where film_id > 500 and I was able to see some trend in the plot.I've added plotting string fields too, so some scenarios in sakila database you can check: 'film_list' or 'nicer_but_slower_film_list' tables, plot fid vs
category
'sales_by_film_category' table, plot total_sales vs category 'payment' table, plot customer_id vs amountAmmar, OK, these scenarios work fine.
Any opinion on Tyron's suggestion about using Highcharts? Otherwise, how do you plan to implement zooming, panning and clickable points?
If Highcharts works well, it would be easier for us to handle just one library for charts.
I would probably have used jquery plugins or write my own code for it. SVG
has <a> and events also so clickable points can be implemented that way. But i'll try highcharts now as tyron suggested.
Hi,
I've used Highcharts to create the plot functionality. For now, it plots for numeric fields only. it is zoomable (both in x and y) and also you can click the data points to view the row. You can try scenarios like: In sakila database: -> In films table, try film_id ( < 100 ) vs rental_rate and choose 'title' as the label. -> In films_actor table, try film_id vs actor_id. etc..
Regards, Ammar Yasir
--
Marc Delisle http://infomarc.info
EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel