Query question

[GMs_for_libs]

I've been using 3D Pie chart to represent data in my temp_results table.

 

For the pir chart I need two values - Count and Language name.

 

The following query successfully produced a chart:

 

 

 

select COUNT(language) as Count, language from temp_results where city='Kyyiv' and group by language;

 

 

 

But later I noticed that in the temp_results I have duplicate records with identical numbers.

 

 

 

My temp_results table has the following fields: number, language, and city.

 

 

 

I've tried the following queries to eliminate the duplicates:

 

 

 

select COUNT(language) as Count, language from temp_results where number=(select distinct number from temp_results where city='$city') group by language;

 

 

 

SELECT COUNT(G) as Count, L FROM (select distinct number as G, language as L from temp_results where city='$city') as tbl;

 

 

 

These queries did not work.

 

 

 

Could you please help me to count distinct records for distinct languages.

 

 

 

Thanks in advance,

 

 

 

olha

[Arindam]

hi olha,

database in MySQL? will you provide us your database backup? then we can test it and give you result.

Edited July 8, 2008 by Guest

[GMs_for_libs]

You can find my temp_results table from which I am building pie charts in the attachment.

 

Fields are terminated by '~'. And yes, I am using MySQL database.

 

 

 

For now I came up with the temporary solution, I just reload the data from temp_results into an additional table

 

without duplicates.

 

 

 

The application that I am working on can be viewed at http://abuchel.apmaths.uwo.ca/~obuchel/maps/search_form1_copy.php (the application works better in Firefox).

 

 

 

I have two more problems with your charts. It would be nice if you could help me solve them too.

 

 

 

1) When I click on any of the items on the legend near my map (see file http://abuchel.apmaths.uwo.ca/~obuchel/maps/search_form1_copy.php) and search, pie charts, histograms and scatter plots linked to markers for each city sometimes show "Now data to display." Could you please explain me why this is happening? Is it because it is a trial version?

 

 

 

2) When I use your 3D Column chart to plot histograms, the chart does not take values before 1900. I have a few years from the XIX century. What should I do to be able to display 1837 or 1857?

 

 

 

Thank you in advance,

 

 

 

Olha

temp_results.txt

[FusionCharts Support]

Hi,

For both  the cases could you please check the XML setting the DebugMode on.

1. "Now data to display" comes when the XML is having no chart data, e.g. <chart></chart> or when XML format is different from the chart type, e.g. XML's format is single series and the chart is multi-series.

2. The charts (except for gantt chart) does not have any time/date handling system. It just takes year as string or number to display. Please check the XML and be sure that there is no issue while fetching data.

[GMs_for_libs]

Thank you for your responses.

 

In number 1, it was a problem with Firefox. Firefox did not like form POST method, with GET, everything works fine.

 

It is strange - it worked before, but stopped recently.

 

In the second case, my problem was with MySQL. MySQL takes years only from this range 1901-2155.

 

 

 

Olha

[GMs_for_libs]

Could you please answer another question:

 

 

 

I am using your SelectScatter (free version) and want to add multiple lines to the tooltext.

 

 

 

I tried adding both <BR> and %26lt;br%26gt; and it did not work.

 

I am using your charts with AJAX and PHP.

 

 

 

Do you have any other suggestions how to add lines to the tooltext?

 

 

 

Thanks,

 

 

 

Olha

[FusionCharts Support]

Hi,

Please also add this style XML :

<styles>

 <definition>

  <style type='font' name='htmlfont' isHTML='1'/>

</definition>

<application>

  <apply toObject='TOOLTIP' styles='htmlfont'/>

</application>

</styles>