Re: Counting, Percentages and Chart Display

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 43689
interpreted = N
texte = [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 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)
[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 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)