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 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/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Counting, Percentages and Chart Display (David Cate 2002)
  2. Re: Counting, Percentages and Chart Display (Andrew Simpson 2002)
  3. Counting, Percentages and Chart Display (David Cate 2002)
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 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/ 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)