<div class="gmail_quote">On Sun, Jun 12, 2011 at 1:14 AM, Ammar Yasir <span dir="ltr"><<a href="mailto:ammaryasir.88@gmail.com">ammaryasir.88@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<br><br><div class="gmail_quote"><div><div></div><div class="h5">On Fri, Jun 10, 2011 at 6:12 PM, Marc Delisle <span dir="ltr"><<a href="mailto:marc@infomarc.info" target="_blank">marc@infomarc.info</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Ammar Yasir a écrit :<br>
<div>><br>
><br>
><br>
> Hi,<br>
><br>
><br>
> 1. Let's say I choose film_actor, activate actor_id and film_id and<br>
> enter 1 as the actor id. When I get the results, I no longer see the<br>
> value I entered in the dialog.<br>
><br>
> But this scenario gives me a notice:<br>
</div><div>> I fixed this issue. The notice comes if you do not select a label, I<br>
> added a default to it so the notice should not come now.<br>
><br>
><br>
> 2. What should I enter as data label to have meaningful results? Please<br>
> give an example.<br>
><br>
> Actually, we had to show a label for each data point. So for example in<br>
> 'film' table or 'actor' table 'name' could be a label for points. I<br>
> haven't implemented showing the label yet, the selection just stores the<br>
> label for each point internally. I thought showing the label for now<br>
> (without the zoom feature) would make the plot very difficult to<br>
> understand.<br>
><br>
><br>
> 3. Did you find a table (in sakila) for which choosing two columns and<br>
> generating a plot would make me recognize some kind of trend in the<br>
> data?<br>
><br>
> As an example, on a copy of the film table I did<br>
> update film_copy set length = length*3 where film_id > 500<br>
><br>
> and I was able to see some trend in the plot.<br>
><br>
> I've added plotting string fields too, so some scenarios in sakila<br>
> database you can check:<br>
> 'film_list' or 'nicer_but_slower_film_list' tables, plot fid vs category<br>
> 'sales_by_film_category' table, plot total_sales vs category<br>
> 'payment' table, plot customer_id vs amount<br>
><br>
<br>
</div>Ammar,<br>
OK, these scenarios work fine.<br>
<br>
Any opinion on Tyron's suggestion about using Highcharts? Otherwise, how<br>
do you plan to implement zooming, panning and clickable points?<br>
<br>
If Highcharts works well, it would be easier for us to handle just one<br>
library for charts.<br>
<br></blockquote></div></div><div>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. <br>But i'll try highcharts now as tyron suggested. <br>
</div><div> </div></div></blockquote><div>Hi,<br>
<br>
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:<br>
In sakila database:<br>
-> In films table, try film_id ( < 100 ) vs rental_rate and choose 'title' as the label.<br>
-> In films_actor table, try film_id vs actor_id.<br>
etc.. <br><br>Regards,<br>Ammar Yasir<br></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
<font color="#888888">
--<br>
</font><div class="im"><div><div></div><div>Marc Delisle<br>
<a href="http://infomarc.info" target="_blank">http://infomarc.info</a><br>
<br>
------------------------------------------------------------------------------<br>
EditLive Enterprise is the world's most technically advanced content<br>
authoring tool. Experience the power of Track Changes, Inline Image<br>
Editing and ensure content is compliant with Accessibility Checking.<br>
<a href="http://p.sf.net/sfu/ephox-dev2dev" target="_blank">http://p.sf.net/sfu/ephox-dev2dev</a><br>
_______________________________________________<br>
Phpmyadmin-devel mailing list<br>
<a href="mailto:Phpmyadmin-devel@lists.sourceforge.net" target="_blank">Phpmyadmin-devel@lists.sourceforge.net</a><br>
<a href="https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel" target="_blank">https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel</a><br>
</div></div></div></blockquote></div><br>
</blockquote></div><br>