Re: Graphical display of sales volume

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 47581
interpreted = N
texte = On 2/8/03 12:30 PM, Alex McCombie wrote: Sorry about that. I missed the 4 searches (you may only need one depending on how many things you would want to compare) that set the max variables of which everything is compared against.Again... Hope this helps.Alex >> Anyone have any pointers on how to tackle this? I'm not sure where to >> start. I guess I could make tables and color the cells as needed, but >> maybe someone who has been down this path has another suggestion...? >> >> Thanks, I pulled this quickly and sanitized it so my apologies if something isnt quiet right. But this tracks various increments in a partner only area of a client site and displays those totals graphically.It does so by comparing the current total against the maximum totals found for each field to create a dynamic range from 0-100% (which changes every chart as soon as a new 100% is reached. Actually it is quite snappy as well. The client has gotten addicted to watching it ;-) You can see a screen image of it here: http://NewWorldMedia.com/chart.gifHTH Alex [search db=daily.db&neDATEINFOdatarq=findall&detotalpasort=1&totalpatype=num] [founditems][showif [index]=1][text]maxPA=[totalpa][/text][/showif][/founditems][/search][search db=daily.db&neDATEINFOdatarq=findall&detotalorderssort=1&totalorderstype=num ] [founditems][showif [index]=1][text]maxorders=[totalorders][/text][/showif][/founditems][/search ][search db=daily.db&neDATEINFOdatarq=findall&detotalPRICINGsort=1&totalPRICINGtype=n um] [founditems][showif [index]=1][text]maxPRICING=[totalPRICING][/text][/showif][/founditems][/sear ch][search db=daily.db&neDATEINFOdatarq=findall&deIVISITORSsort=1&IVISITORStype=num] [founditems][showif [index]=1][text]maxVISITORS=[IVISITORS][/text][/showif][/founditems][/search ][search db=daily.db&neDATEINFOdatarq=findall&deDATEINFOsort=1&DATEINFOtype=DATE] [founditems] [text]mathPA=[math][totalPA]/[maxpa]*100[/math][/text] [text]mathorders=[math][totalorders]/[maxorders]*100[/math][/text] [text]mathPRICING=[math][totalPRICING]/[maxPRICING]*100[/math][/text] [text]mathVISITORS=[math][IVISITORS]/[maxVISITORS]*100[/math][/text][totalPA] [Format .0f][mathpa][/format]%[totalorders] [Format .0f][mathorders][/format]%[totalPRICING] [Format .0f][mathPRICING][/format]%[IVISITORS] [Format .0f][mathVISITORS][/format]% [/founditems][/search]Alex J McCombie New World Media Chief Information Officer Drawer 607 800/724.8973 Fair Haven, NY 13064 Alex@NewWorldMedia.com http://OurClients.comInterface Designer WebDNA Programmer Database Designer------------------------------------------------------------- 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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Graphical display of sales volume (WJ Starck 2003)
  2. Re: Graphical display of sales volume (Gary Krockover 2003)
  3. Re: Graphical display of sales volume (Alex McCombie 2003)
  4. Re: Graphical display of sales volume (Alain Russell 2003)
  5. Re: Graphical display of sales volume (Alex McCombie 2003)
  6. Re: Graphical display of sales volume (Charles Kline 2003)
  7. Re: Graphical display of sales volume (Gary Krockover 2003)
  8. Graphical display of sales volume (WJ Starck 2003)
On 2/8/03 12:30 PM, Alex McCombie wrote: Sorry about that. I missed the 4 searches (you may only need one depending on how many things you would want to compare) that set the max variables of which everything is compared against.Again... Hope this helps.Alex >> Anyone have any pointers on how to tackle this? I'm not sure where to >> start. I guess I could make tables and color the cells as needed, but >> maybe someone who has been down this path has another suggestion...? >> >> Thanks, I pulled this quickly and sanitized it so my apologies if something isnt quiet right. But this tracks various increments in a partner only area of a client site and displays those totals graphically.It does so by comparing the current total against the maximum totals found for each field to create a dynamic range from 0-100% (which changes every chart as soon as a new 100% is reached. Actually it is quite snappy as well. The client has gotten addicted to watching it ;-) You can see a screen image of it here: http://NewWorldMedia.com/chart.gifHTH Alex [search db=daily.db&neDATEINFOdatarq=findall&detotalpasort=1&totalpatype=num] [founditems][showif [index]=1][text]maxPA=[totalpa][/text][/showif][/founditems][/search][search db=daily.db&neDATEINFOdatarq=findall&detotalorderssort=1&totalorderstype=num ] [founditems][showif [index]=1][text]maxorders=[totalorders][/text][/showif][/founditems][/search ][search db=daily.db&neDATEINFOdatarq=findall&detotalPRICINGsort=1&totalPRICINGtype=n um] [founditems][showif [index]=1][text]maxPRICING=[totalPRICING][/text][/showif][/founditems][/sear ch][search db=daily.db&neDATEINFOdatarq=findall&deIVISITORSsort=1&IVISITORStype=num] [founditems][showif [index]=1][text]maxVISITORS=[IVISITORS][/text][/showif][/founditems][/search ][search db=daily.db&neDATEINFOdatarq=findall&deDATEINFOsort=1&DATEINFOtype=DATE] [founditems] [text]mathPA=[math][totalPA]/[maxpa]*100[/math][/text] [text]mathorders=[math][totalorders]/[maxorders]*100[/math][/text] [text]mathPRICING=[math][totalPRICING]/[maxPRICING]*100[/math][/text] [text]mathVISITORS=[math][IVISITORS]/[maxVISITORS]*100[/math][/text][totalPA][math][totalPA]/[maxpa]*100[/math][/format]> [Format .0f][mathpa][/format]%[totalorders] [math][totalorders]/[maxorders]*100[/math][/format]> [Format .0f][mathorders][/format]%[totalPRICING] [math][totalPRICING]/[maxPRICING]*100[/math][/format]> [Format .0f][mathPRICING][/format]%[IVISITORS] [math][IVISITORS]/[maxVISITORS]*100[/math][/format]> [Format .0f][mathVISITORS][/format]% [/founditems][/search]Alex J McCombie New World Media Chief Information Officer Drawer 607 800/724.8973 Fair Haven, NY 13064 Alex@NewWorldMedia.com http://OurClients.comInterface Designer WebDNA Programmer Database Designer------------------------------------------------------------- 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://webdna.smithmicro.com/ Alex McCombie

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:

emailer (1998) WebCatalog can't find database (1997) expire headers in mac305b11 (1999) AppleScript: Tell application:app location? (1998) searchable list archive (1997) Transfer of data from Invoice to thank you templates (1998) Just Testing (1997) http upload (2001) RE: Webcat 2.0.1b1 bug with IE 3.01/4.0p1 (1997) Problem (1997) [include file=filename.inc&strip=t] (2002) Grepping to remove text & code (2004) Navigator 4.01 (1997) 2nd WebCatalog2 Feature Request (1996) [LOOKUP] (1997) Netscape 3.01 can't see db in form (was problems problemsproblems) (1997) WebCat2b15MacPlugin - showing [math] (1997) DNS Lookup 2 (2000) protect tag not working (1998) Checking for blank form fields (sort of...) (1998)