Re: Graphical display of sales volume

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 47583
interpreted = N
texte = Thanks guys...That definitely gets me started...! On Saturday, February 8, 2003, at 09:16 PM, Gary Krockover wrote:> Nice, added that to my personal snippet collection, thanks! > > GK > > >> 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.gif >> >> HTH >> 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&totalorderstyp > e=num >> ] >> [founditems][showif >> > [index]=1][text]maxorders=[totalorders][/text][/showif][/founditems][/ > search >> ] >> >> [search >> > db=daily.db&neDATEINFOdatarq=findall&detotalPRICINGsort=1&totalPRICINGt > ype=n >> um] >> [founditems][showif >> > [index]=1][text]maxPRICING=[totalPRICING][/text][/showif][/ > founditems][/sear >> ch] >> >> [search >> db=daily.db&neDATEINFOdatarq=findall&deIVISITORSsort=1&IVISITORStype=n >> um] >> [founditems][showif >> > [index]=1][text]maxVISITORS=[IVISITORS][/text][/showif][/founditems][/ > search >> ] >> >> [search >> db=daily.db&neDATEINFOdatarq=findall&deDATEINFOsort=1&DATEINFOtype=DAT >> E] >> [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] >> >> >> >> > size=1>[totalPA]> size=1>> src=bar.gif height=10 width=[Format >> .0f][math][totalPA]/[maxpa]*100[/math][/format]> [Format >> .0f][mathpa][/format]% >> >> SIZE=1>[totalorders] >> > height=10 width=[Format >> .0f][math][totalorders]/[maxorders]*100[/math][/format]> [Format >> .0f][mathorders][/format]% >> >> > size=1>[totalPRICING] >> > height=10 width=[Format >> .0f][math][totalPRICING]/[maxPRICING]*100[/math][/format]> [Format >> .0f][mathPRICING][/format]% >> >> > size=1>[IVISITORS] >> > height=10 width=[Format >> .0f][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.com >> >> Interface 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/ > > --Will Starck NovaDerm Skincare Science http://www.novaderm.com wjs@novaderm.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://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)
Thanks guys...That definitely gets me started...! On Saturday, February 8, 2003, at 09:16 PM, Gary Krockover wrote:> Nice, added that to my personal snippet collection, thanks! > > GK > > >> 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.gif >> >> HTH >> 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&totalorderstyp > e=num >> ] >> [founditems][showif >> > [index]=1][text]maxorders=[totalorders][/text][/showif][/founditems][/ > search >> ] >> >> [search >> > db=daily.db&neDATEINFOdatarq=findall&detotalPRICINGsort=1&totalPRICINGt > ype=n >> um] >> [founditems][showif >> > [index]=1][text]maxPRICING=[totalPRICING][/text][/showif][/ > founditems][/sear >> ch] >> >> [search >> db=daily.db&neDATEINFOdatarq=findall&deIVISITORSsort=1&IVISITORStype=n >> um] >> [founditems][showif >> > [index]=1][text]maxVISITORS=[IVISITORS][/text][/showif][/founditems][/ > search >> ] >> >> [search >> db=daily.db&neDATEINFOdatarq=findall&deDATEINFOsort=1&DATEINFOtype=DAT >> E] >> [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] >> >> >> >> > size=1>[totalPA]> size=1>> src=bar.gif height=10 width=[Format >> .0f][math][totalPA]/[maxpa]*100[/math][/format]> [Format >> .0f][mathpa][/format]% >> >> SIZE=1>[totalorders] >> > height=10 width=[Format >> .0f][math][totalorders]/[maxorders]*100[/math][/format]> [Format >> .0f][mathorders][/format]% >> >> > size=1>[totalPRICING] >> > height=10 width=[Format >> .0f][math][totalPRICING]/[maxPRICING]*100[/math][/format]> [Format >> .0f][mathPRICING][/format]% >> >> > size=1>[IVISITORS] >> > height=10 width=[Format >> .0f][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.com >> >> Interface 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/ > > --Will Starck NovaDerm Skincare Science http://www.novaderm.com wjs@novaderm.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://webdna.smithmicro.com/ WJ Starck

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 Database Format (1997) Extended [ConvertChars] (1997) unable to launch acgi in WebCat (1997) upgrading (1997) Change Subtotal (2000) Help Please WebDNA 6 Secure Forms Problem (2004) Forms Search Questions (1997) Re[2]: HELP: OS X Problem... (2000) Generating Searches on the fly? (1999) [WebDNA] TCPCONNECT & Timeout (2015) WebCat2.0 [format thousands .0f] no go (1997) WebCat2 - Getting to the browser's username/password data (1997) Webmerchant confirmation hooks? (1997) WebCat2: Items xx to xx shown, etc. (1997) Search/sort in URL Was: GuestBook example (1997) merchant accts. (1997) Re:Emailer tracking (1997) value=[variable] (2001) [SearchString] problem with [search] context (1997) Re:Still More on EudoraPro Email (1998)