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:

WC 4.0 on OSX 10.0.4 problems (2001) Fun with dates (1997) WCS Newbie question (1997) [WebDNA] Formatting text (2011) Its not that weird. (1997) StoreBuilder and PayPal (2002) Download URL & access on the fly ? (1997) Trouble with adding multiple items to cart (1999) Another question (1997) sorting... (2003) [cart]'s ever get recycled? (2000) WebCat2b15MacPlugin - [protect] (1997) Ship Cost Calculated via Subtotal (1998) Trouble with formula.db (1997) [WebDNA] HTML [sendmail] revisited (2009) Attn: Bug in GeneralStore example b15 (1997) Newbie questions (2000) Deleting Orders (1997) Searching an Email database (1997) restart needed???? (1997)