Counting, Percentages and Chart Display
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 43688
interpreted = N
texte = 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 BreakdownZip Code Users Audience37664: 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 CateNew Media DirectorThe GoTriCities Networkhttp://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/
Associated Messages, from the most recent to the oldest:
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 BreakdownZip Code Users Audience37664: 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 CateNew Media DirectorThe GoTriCities Networkhttp://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/
David Cate
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:
Menu to select product variations (1997)
Adding up line items. (2000)
RE: Re:Signal Raised (1997)
[WebDNA] Max upload file size (2010)
WebCat2 - Getting to the browser's username/password data (1997)
Next (1997)
WebCatalog on Linux/MacOSX/etc (2000)
[Sum] function? (1997)
Webcat & SIMS (1998)
Showif for mulitple variations (1997)
Multiple SSL Keys (1998)
Webcat/Webmerchant (1998)
[WebDNA] Downloadable docs (2011)
Add message to Order (1997)
Summary search -- speed (1997)
Next (1997)
Error Lob.db records error message not name (1997)
WebCat and AppleShare 6.0 (1998)
Search in 2 or more catalogs (1997)
[WebDNA] Update on WebDNA? (2011)