Re: Graphical display of sales volume

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 47577
interpreted = N
texte = On 2/8/03 10:41 AM, WJ Starck wrote:> 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&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 10:41 AM, WJ Starck wrote:> 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&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:

Trigger Error (2001) A question on sub-categories (1997) WC2.0 Memory Requirements (1997) WebCatalog NT beta 18 problem (1997) Looking for a Manual (1997) [SearchString] problem with [search] context (1997) Sort Order on a page search (1997) Re2: frames & carts (1997) Loss in form (1998) more on quicktime test stuff (1997) Help! WebCat2 bug (1997) WebCat2 - [format thousands] (1997) FEATURE REQUEST: (was: Summarizing results. Is there a shortcut? (1999) WebCat2b13MacPlugIn - More limits on [include] (1997) Updating fields from different platforms (1998) # fields limited? (1997) Webcat causing crashes left and right! (1997) [WebDNA] Problem saving returned value as a variable (2012) User/pass with tcpconnect (2000) RE: AccountAuthorizer doesn't seem to work (1997)