Re: Counting, Percentages and Chart Display
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 43689
interpreted = N
texte = [searchdb=zip.db&neZIP_CODEdatarq=[BLANK]][founditems][text]total_users=[numfound][/text][/founditems][/search][search db=zip.db&neZIP_CODEdatarq=[BLANK]&ZIP_CODEsumm=T][text]total_zip_codes=[numfound][/text][founditems] [text]the_current_zip=[ZIP_CODE][/text] [searchdb=zip.db&eqZIP_CODEdatarq=[the_current_zip]&neUSER_IDdatarq=[BLANK]] Zip Code = [the_current_zip] - Users = [numfound] - Percentage =[format 8.2f][math][numfound]/[total_users]*100[/math][/format] [/search][/founditems][/search]----- Original Message -----From: David Cate
To: WebCatalog Talk Sent: Monday, September 23, 2002 12:42 PMSubject: Counting, Percentages and Chart Display> I've worked myself into a headache this evening trying to figure this> one out and as a last resort, before Ibuprofen, I was hoping that> someone could give me a bit more advice.>> I have a database where I am collecting zip codes from users and would> like to search the zip code field, list the various zip codes, total the> users and display a percentage display of where users are coming from.>> Example: Zip Code Breakdown>> Zip Code Users Audience> 37664: 378 24.5%> 37663: 245 24.5%> 37662: 175 15.5%> Other: 356 38.2%>> I'm thinking that I would need to sort the field, use a numfound for the> users, but I can't seem to understand how to show the percentages. I've> also considered using the BarChart example to display this info using a> graph, but I'm unable to connect the thoughts.>> If anyone could give me as to what I need to explore in the> documentation... I would appreciate it.>> Always thankful...>> David Cate> New Media Director> The GoTriCities Network> http://www.gotricities.net>>> -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to> Web Archive of this list is at: http://search.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
[searchdb=zip.db&neZIP_CODEdatarq=[BLANK]][founditems][text]total_users=[numfound][/text][/founditems][/search][search db=zip.db&neZIP_CODEdatarq=[BLANK]&ZIP_CODEsumm=T][text]total_zip_codes=[numfound][/text][founditems] [text]the_current_zip=[ZIP_CODE][/text] [searchdb=zip.db&eqZIP_CODEdatarq=[the_current_zip]&neUSER_IDdatarq=[BLANK]] Zip Code = [the_current_zip] - Users = [numfound] - Percentage =[format 8.2f][math][numfound]/[total_users]*100[/math][/format] [/search][/founditems][/search]----- Original Message -----From: David Cate To: WebCatalog Talk Sent: Monday, September 23, 2002 12:42 PMSubject: Counting, Percentages and Chart Display> I've worked myself into a headache this evening trying to figure this> one out and as a last resort, before Ibuprofen, I was hoping that> someone could give me a bit more advice.>> I have a database where I am collecting zip codes from users and would> like to search the zip code field, list the various zip codes, total the> users and display a percentage display of where users are coming from.>> Example: Zip Code Breakdown>> Zip Code Users Audience> 37664: 378 24.5%> 37663: 245 24.5%> 37662: 175 15.5%> Other: 356 38.2%>> I'm thinking that I would need to sort the field, use a numfound for the> users, but I can't seem to understand how to show the percentages. I've> also considered using the BarChart example to display this info using a> graph, but I'm unable to connect the thoughts.>> If anyone could give me as to what I need to explore in the> documentation... I would appreciate it.>> Always thankful...>> David Cate> New Media Director> The GoTriCities Network> http://www.gotricities.net>>> -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to> Web Archive of this list is at: http://search.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Andrew Simpson
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
format problem on NT? (1997)
Grant, please help me ... (1997)
ShowNext (1997)
WCS Newbie question (1997)
plugin-acgi, different results (1997)
[WebDNA] Different results for [THISURL] (2018)
The Form authentication trick (2000)
[random] only for 1-100??? (1997)
Duplicate Carts (2000)
[Sum] function? (1997)
[WebDNA] REPLACE INCLUDE FILE (2019)
ConvertChars request (1999)
ShowIf & HideIf Question? (1998)
Emailer 1.01 bombs (1997)
Not really WebCat (1997)
Verifying both name and password (was: THANKS) (1997)
Nested tags count question (1997)
Correlating the record found with the fieldname (2000)
shipcost - cleaner with a table (1998)
apache 2.x (2002)