What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

Re: Counting, Percentages and Chart Display

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 43690
interpreted = N
texte = Thanks Andrew. Wow!I'll give it a try and let you know, but it looks like great logic.DavidOn Sunday, September 22, 2002, at 08:56 PM, Andrew Simpson wrote:> [search > db=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] > [search > db=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 PM > Subject: 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 digest@talk.smithmicro.com> > Web Archive of this list is at: http://search.smithmicro.com/ > > David Cate New Media Director The GoTriCities Network http://www.gotricities.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:

    
  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)
Thanks Andrew. Wow!I'll give it a try and let you know, but it looks like great logic.DavidOn Sunday, September 22, 2002, at 08:56 PM, Andrew Simpson wrote:> [search > db=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] > [search > db=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 PM > Subject: 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 digest@talk.smithmicro.com> > Web Archive of this list is at: http://search.smithmicro.com/ > > David Cate New Media Director The GoTriCities Network http://www.gotricities.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/ 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:

Going to anchors within a template page (1997) Using [detete] (1998) Upgrade on MacOSX 3.05 to 3.08 (2000) [applescript] (1999) File upload to database ? (2001) OT: Google (2002) OT: need bad code (2005) Re2: frames & carts (1997) Announcement-WebCatalog 2.0 Released (1997) absolute paths for databases? (1997) The word TYPE in search contexts and fields (1998) Date search bug (1997) Fun with Dates - revisited (1997) WebCat2 beta 11 - new prefs ... (1997) Here we go again...WebDNA - SQL- Clustering (2006) Users and groups for local directories (1999) price change help (1998) Showif, Hideif reverse logic ? (1997) Keeping track of revision history, etc. (2005) Shared conversion under WebTen (1998)